dax measure

Hello, firstly, Hello to all - I am new to the fourm. I hope someone can help me, I have a model that has two tables for Forecast (Labour and Non-Labour) The issue I have is that I would like to be able to view the data in one field in the pivot table. at the moment I have them as. e.g...

Hi all! I'm desperately trying to get PowerPivot to count the number of 'L's in a column. L itself is a measure, which returns 'L' for stores which have not bought in over a year (and are therefore Lost) and blank for all other cases. When I try the following function...

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...

Hi at all. can you please help me to find a one formula instead of the following calculated columns that i have? AmountUSD = [TransactionAmount]/CALCULATE(VALUES(factExchangeRate[AverageRate])) AmountGBP = [AmountUSD]* CALCULATE(VALUES(factExchangeRate[AverageRate])...

I have been using several excel files as the data sources for a PowerPivot report I publish quarterly. One of the tables has finally grown to over 1 million rows, which .xlsx does not support. Consequently, I cannot append this quarter's data to it and refresh my PowerPivot report. I've...

Guys, this has been making me insane for the last few days, can anyone give me hand. I need the % of a grand total for every row in my pivot table. HOWEVER I need calculate a few things before that. Bear with! The example below gives me the total volume of a product by two months broken down...