Forum Discussion
COUNT and PERCENT over specific ROW
I am having a hard time figuring out how to do a simple % over a specific row in a Matrix - thought it would just be a simple calculation but apparently it's not that easy? I have a matrix with 3...
tviz21 - Perhaps a Measure such as:
Measure = CALCULATE(VAR Denominator = COUNTX(ALL(types),[Type]) VAR Numerator = COUNT([Type]) RETURN Numerator/Denominator)
Make sure to format as %.
tviz21 - For clarity, my table is called "types" and I have a single column in that table called "Type". I put the following data in it:
Type
1
2
3
2
3
My matrix shows:
Type Measure
1 20%
2 40%
3 40%
