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.
Hi, community,
I'm trying to get the cumulative total calls in my data monthwise.
As you can see if I'm using the Month number then the cumulative is working perfectly.
But in Month's case, it is not working.
Is there any workaround if I want it monthwise?
used the following Dax measure.
Solved! Go to Solution.
@Niraj_vora0106 , First of if you have date table, then you should use the month from dates table. Second distinct count will not sum , because same id can repeat across month
Also you can use date, no need to use month, you can try like
V3 Cumulative Total Calls =
CALCULATE(DISTINCTCOUNT(T2363[IncidentNo]),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))
or
V3 Cumulative Total Calls =
CALCULATE(sumx(Values(Dates[Month]), calculate(DISTINCTCOUNT(T2363[IncidentNo]))),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))
Hi, @amitchandak
Oh okay got it, used the Months from Dates column and tried the DAX that you suggested.
Got the outcome.
Thank you, sir!
@Niraj_vora0106 , First of if you have date table, then you should use the month from dates table. Second distinct count will not sum , because same id can repeat across month
Also you can use date, no need to use month, you can try like
V3 Cumulative Total Calls =
CALCULATE(DISTINCTCOUNT(T2363[IncidentNo]),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))
or
V3 Cumulative Total Calls =
CALCULATE(sumx(Values(Dates[Month]), calculate(DISTINCTCOUNT(T2363[IncidentNo]))),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |