measures

I bet there is a simple formula for this, but I'm new to power pivot and DAX and I can't get this to work how I would like. I created a power pivot table with the Row Label "Activity" and the values "Activity Total" and "Activity Count". Activity total is the dollars associated with the Activity...

Hello, I have a "Measure" slicer that allows you to select either Nominal, YoY Growth %, or 5yr CAGR %. I then have a DAX measure that calculates based on what is selected in the "Measure" slicer: Measure Type = IF([isReportSlicerSet],SWITCH(VALUES('Measure'[Measure]),"Nominal",[Total...

I'm fairly new to powerpivot. I have many Columns in my pivot table. One of the columns is showing 2013 sales by account. the next column is showing 2014 sales by account. For both of these columns i used the "options" tab and went to the "show values as" calculation area and chose "% of grand...

Hi I have just started using PP and need help. I need to calculate the number of current and terminated employees for a given month. An employee is considered active at the beginning of a month if start date <= first day of month and termination date is blank or >= second day of the month...

I have a slicer attached to a PowerPivot pivot table that filters for a field called Project_Code. I need to display another field (Project_Text) above the pivot table, that is associated with whichever Project_Code is selected. So, I wrote a measure to be sure that I only return a value...

I used the RELATED formula to to create a Calculated Column called fact_ActualsOrders_ES[Accrual] or "Accrual": =IF(related(dim_posting[doc_type_cd])="YK",1,0) The values came over correctly, so I created (3) measures to calculate the the total amount, all the "1"s, and all the "0"s...

Hello,Summary of my problem: Because of memory issues, I would like to create PowerPivot Reports that are summed at a high detail level, but the calculations are done at a granular detail level. Here is a simplified version of the details of my problem: -I am using the 32 bit version of Excel...

Hi all, I'm relatively new to PowerPivot, so this question is probably going to make you laugh. Anyway, I'd appreciate it if someone could help me on this. I have 2 data tables. One shows the amount of clicks on a website in 5-minute buckets (per day), the other one shows the amount of seconds...

Hello Community, I'm a newbie to powerpivot/dax. I have created three measures: 2011 sales, 2012 sales, and 2013 sales (a simple calculation, sum sales where year = 2011, etc...) I wish to create a 4th measure: 3-Yr Max Sales, which calculates the max of 2011 Sales, 2012 Sales, and 2013...

Hi I am having issues with measures that were built in Powerpivot 32bit. The measures are in the form: Booking_2012:=calculate('vXXXX'[Sum of Bookings],'vXXXX'[Year]="2012") with vXXXX the tab name. I have reopened on the 32bit machine and measures are still valid, but have the following...

I am using the below measure in PowerPivot (Excel 2013): =CALCULATE(COUNTA(ShoppingCart[Fruit]), ShoppingCart[Fruit]="Apple") This will give me the the number of records in the "Fruit" column that are equal to "Apple". I'd like to include "Oranges" in my filter, so that I can have a count of...