Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am currently trying to get cumulative sum of my sample data as in picture. but instead of Cumulative Variance and Cumulative Sales i am getting same as the normal variance and Cumulative sales. I have pasted my DAX code as well but it is not working.
I have slicers on datetime,pharmaid,base,base group (currently only datetime and pharma id are selected)
This is the dax formaula used for Cumulative variance and Sales -
Cumulated Variance =
CALCULATE (
SUM (Table1'[Variance]),
FILTER(ALLSELECTED(Table1[DateTime],Table1[pharmaSiteld]),
Table1[DateTime] <=MAX(Table1[DateTime])
)
Can someone please help me
Try
CALCULATE(
COUNTA('Table1'[Variance]),
FILTER(
ALLSELECTED('Table1'[DateTime]),
ISONORAFTER('Table1'[DateTime], MAX('Table1'[DateTime]), DESC)
)
)
This is Giving all rows as 1 in cumulative sum. Can you please try once more?
Ok, I guess you should use Sum instead of Count.
Or if your Variance column is already a measure, then just use that instead.
Yes i have already given my DAX formula, but it is not giving the cumulative sum i need. can someone please help on this.
I have been trying for 2 days and still got no solution.
Instead of cumulative sum i am getting same value as variance column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |