Forum Discussion
JayTG123
Advocate I
Advocate IHow to get a percentage when using slicers
Hi all, I am trying to figure out how to get a percentage on the below. 12,474 is Octbers Figure of all data on the two donut graphs (minus HA Imposed Change on the right graph) I would like a percen...
Hi JayTG123,
Is the Organisation field on a different table? If so, you''ll probably need to apply an ALL to that as well
KPI 1 All Orgs = CALCULATE([KPI 1 Total],ALL(OrgTable),ALLEXCEPT([PAAs & PAs Received],[Month]))
There's probably a more elegant way of doing it, but it's a bit tricky with limited knowledge of how your data is structured
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
mattww
Responsive Resident
Responsive ResidentHi JayTG123,
Is the Organisation field on a different table? If so, you''ll probably need to apply an ALL to that as well
KPI 1 All Orgs = CALCULATE([KPI 1 Total],ALL(OrgTable),ALLEXCEPT([PAAs & PAs Received],[Month]))
There's probably a more elegant way of doing it, but it's a bit tricky with limited knowledge of how your data is structured
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
