I have a Master Measure that calculates a percentage for a column in my table.
When I use this version the grand total is 17.0%
(Count({<DestName={'SNF'}>} AGE)) /
(Count(AGE))
When I use this version the grand total is 20.1%
//Aggr(Count({<DestName={'SNF'}>} AGE), ServiceLineDescription) /
//Aggr(Count(AGE), ServiceLineDescription)
The actual total is really 20.4% which I get when I calculate a variable with
Num(Count({<DestName={'SNF'}>} AGE)/Count(AGE), '##0.0%') and display the result.
Something is happening inside the table that is not happening in the variable.
The calculation for each row for this % is correct. It is just the total row that is off a bit.
What do I need to change to make the total correct with 20.4%?
