Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, cumulative counts are covered extensively here but I can't see an answer to my specific problem.
I'm trying to cumulatively count the number of calls a team of agents make in a day and benchmark them against a cumulative KPI.
First I summarize the the number of agents per day based on the calls table.
You can see in the images above when I inclide a date on the trend axis for the KPI the calls KPI is cumulative however the actual count of calls made is not. Removing the date gives the true cumulative figure for calls made but removes the trend axis.
Can someone please help?
Hi,
You have ALLSELECTED in your formula, this might be restricting your data.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
If you share you data model, some detailed sample data, it can easily be fixed.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi,
Thanks for the response. I've tried a few different filters within the CALCULATE function and nothing seems to work. I've tried ALL and also tried date < MAX(date). Can't understand why it works for the "Calls KPI" measure but not for the actual count of the calls.
Probably should have mentioned I'm struggling to get my head around context!
Cheers,
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |