Forum Discussion

tviz21's avatar
tviz21
New Member
10 years ago

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's avatar
tviz21
New Member
10 years ago

After playing around with this for a while, I ended up with -

 

Percent = CALCULATE(VAR Denominator = COUNTROWS(ALL('type'[Types])) VAR Numerator = COUNTA('type'[Types]) RETURN Numerator/Denominator
)

 

This gave me an overall percentage which I can filter for the different dimensions I have on my dashboard.

 

Thanks to both of you for your help! I'll definitely spend more time with both solutions to understand them better as I'm sure I'll need them later.

 

Toni

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

No need for CALCULATE() or variables in that measure. It should be identical to the much cleaner:

Percent =
COUNTA( 'type'[Types] ) / COUNTROWS( ALL( 'type'[Types] ) )

CALCULATE() is only used to modify filter context or transform row context to filter context. Since this is a measure, there is already filter context coming in from the report and the visual's labels, and there is no row context in a measure, except within an iterator function.

 

The variables are likewise superfluous, because there is no alternate context in which you reference them. If a variable is defined in the same context as it is referenced in, then it's exactly the same as just using the variable definition in-line.