Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a Measure for Revenue, and I was trying to calculate the Commulative Total, but it's not displaying correct values.
as the formula for the Commulative total I used is:
Cummulative =
CALCULATE(
Sales[Revenue],
FILTER(
ALLSELECTED('Calendar'),
'Calendar'[Date] <= Max('Calendar'[Date])))
See the Screen Shot
For the year 2014, Month January
Day 1: Revenue is 3,300 , Commulative is 3,300 which is correct!
Day 2: Revenue is 694,200, Commulative is 793,800 which is WRONG!!
The whole commulative is showing incorrect values.
Kindly help!!
Hi @MH3 ,
We can use the following measure to meet your requirement.
Cummulative =
CALCULATE(
SUMX(VALUES('Calendar'[Date]),'Sales'[Measure revenue]),
FILTER(
ALLSELECTED('Calendar'),
'Calendar'[Date] <= Max('Calendar'[Date])))
Then result like this,
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@MH3 , I am assuming this a measure like this
Cummulative =
CALCULATE(
sum(Sales[Revenue]),
FILTER(
ALLSELECTED('Calendar'),
'Calendar'[Date] <= Max('Calendar'[Date])))
Also make sure year, month or any other time related stuff is taken from Calendar in visual
Hello @amitchandak ,
Sales[Revenue] is already a measure does it needs to be in SUM function? and I have used this formula but still I am not getting correct results.
Help!
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |