Forum Discussion
lisago1978
Helper III
Helper IIICalculating % category using same dynamic sum as denominator
I am trying to figure out how to create a % for a category using the same denominator across all rows Table 1 has the calculated measure that is a summation of the No Health variable (e.g. the de...
Hi , lisago1978
Just need to change your measure as below:
% Category = CALCULATE(DIVIDE([ID_Count],[Total]))Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-easonf-msft
Community Support
Community SupportHi , lisago1978
Just need to change your measure as below:
% Category = CALCULATE(DIVIDE([ID_Count],[Total]))
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.