Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |