Forum Discussion
Grand Total is not correct
The grand total of percentages will be the weighted average.
Example:
6,962 of 10,240 = 67.99%
7,971 of 10,000 = 79,71%
Grand total:
6,962+7,971 = 14,933
10,240 + 10,000 = 20,240
14,933 of 20,240 = 73.78%
It makes sense. I understood. Well do you have any suggestions do get 73.85 value?
Also how did you find 10,240 and 10,000 values?
Second question first; I started with 6,799/10,000 and 7,971/10,000 and then started muliplying the first 2 values with a factor (trial and error). Factor 1.024 gave the outcome I was looking for.
First question: don't know why you wouldn't want to do that, but anyhow you can calculate the percentages as a calculated column and then include the average values in your report.
I didn't understand your solution. It looks correct but i don't know how use it.
Calculated column may work but I get value of 67.99 and 79.71 by (MeasureA-MeasureB)/MeasureA formula. So i don't know how can make a calculated column. MeasureA =SUM(Column1NUMBER) and MeasureB = DISTINCTCOUNT(Column2STRING) ( Also both of those columns are coming from different tables)
BTW; I use Tabular as source and work Live on PowerBI.
Hi aslan,
Calculated column may work but I get value of 67.99 and 79.71 by (MeasureA-MeasureB)/MeasureA formula.
Instead of using (MeasureA-MeasureB)/MeasureA, could you try the formula below to see if it works to get the right Grand Total you need?:smileyhappy:
Percentage = SUMX ( 'TableName', ( [MeasureA] - [MeasureB] ) / [MeasureA] )
Note: The 'TableName' is the name of your table whose column you're showing on the Table/Matrix with the Percentage measure.
Regards
