Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a very simple Calculate that was working yesterday. Today it is broken.
Number of Calls Flagged = DISTINCTCOUNT(PhoneTopics[Number--Date])
Total Care Calls Flagged = CALCULATE([Number of Calls Flagged], PhoneTopics[Type]="Care", ALL('Call Topics'[Topic]))
%Flagged = DIVIDE([Number of Calls Flagged], [Total Care Calls Flagged])
Originally, the Total Care Calls added the grand total for all flagged calls to each topic row. then % flagged did its magic. Now, for some reason, Number of Calls Flagged and Total Care Calls Flagged match meaning that the Calculation is not using the ALL to remove the call topic filters.
I have tried new calculations, slicers, dicers, and exorcisers to no avail. Anyone have this happen before?
See below
@KHorsemanor @MattAllington can you help?
Proud to be a Super User!
Solved! Go to Solution.
Have you by any chance changed the default Sort on any of the columns involved?
I almost started rebuilding a data model because of ALL ( )
http://community.powerbi.com/t5/Desktop/ALL-Function-Mystery/td-p/107458
I did just add a sort by column . . . Wow. I have beat myself over the head with this so much that I can no longer even make sense of the links you provided to write a fix. It is as if my brain has given up and left for the day because the measures were way too simple to give me the issue I was experiencing.
I think I will take a lunch and come back an re-read those links and maybe when I am not Hangry, I will experience an epiphany on how to fix the issue.
Thanks to you, at least I know why it isn't working.
EDIT: I solved my issue short term using quick calculations in desktop. I went back after reading Sean's messages and links and changed the calcuation to fix the issue long-term with:
%Flagged = DIVIDE([Number of Calls Flagged], CALCULATE([Number of Calls Flagged], ALL('Call Topics'[Topic], 'Call Topics'[Sort Order])))
Proud to be a Super User!
Have you by any chance changed the default Sort on any of the columns involved?
I almost started rebuilding a data model because of ALL ( )
http://community.powerbi.com/t5/Desktop/ALL-Function-Mystery/td-p/107458
I cheated, slightly. Since I needed this before lunch to present an idea, I used the quick calc feature to force another measure into the % of grand total I needed. This at least buys me time for lunch.
Proud to be a Super User!
I did just add a sort by column . . . Wow. I have beat myself over the head with this so much that I can no longer even make sense of the links you provided to write a fix. It is as if my brain has given up and left for the day because the measures were way too simple to give me the issue I was experiencing.
I think I will take a lunch and come back an re-read those links and maybe when I am not Hangry, I will experience an epiphany on how to fix the issue.
Thanks to you, at least I know why it isn't working.
EDIT: I solved my issue short term using quick calculations in desktop. I went back after reading Sean's messages and links and changed the calcuation to fix the issue long-term with:
%Flagged = DIVIDE([Number of Calls Flagged], CALCULATE([Number of Calls Flagged], ALL('Call Topics'[Topic], 'Call Topics'[Sort Order])))
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |