Total of percentage/market share wrong

[davor_adl]

Hi,

does anyone know why Power BI doesn't calculate the market share correct for the grand total and show me instead of the average?

These are market share percentages regarding to an item which is hidden and 100%.

So the grand total should show 86,38% from total market and not the average of 7,85%.

The percentage is an measure field which simple calculates item/markettotal and does ist correct for each item but not for the grand total (As written which is not the 100%).

Kr,
DKVC

[v-yuta-msft · Accepted solution]

@davor_adl ,

You can convert the measure to calculate column and then create a measure to achieve the grand total of percentage as below:

Total Percentage =
SUM ( Table[Calculate Column] )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[davor_adl]

Thank you for your input.

But is there a solution that explains why the system doesn't sum the percentage equal as the absolute amount and calculates instead of the avarage of the percentage?

[v-yuta-msft]

@davor_adl ,

Because the simply sum up the percentage will make no sense to the model.

Regards,

Jimmy Tao