create a graph where I have the market share of 3 brands (values) and 10 countries (Axis).

[Michaelkuesten]

Hello, I want to create a graph where I have the market share of 3 brands (values) and 10 countries (Axis).

The problem is that the % of grand total is made only one the filtered 10 countries but I want the total to be made on all countries on my database. Is it possible ?

[ray_ux · Accepted solution]

@Michaelkuesten 

Yes it's possible.

You'll need to create a measure

YourMeasure =
VAR CurrentTotal = SUM(YourValueColumn)
VAR AllTotal = 
CALCULATE( 
  SUM(YourValueColumn)
  ,ALLEXCEPT(YourTable , YourBrandColumn , AnyOtherColumnsYouWantToGroupBy )
)
RETURN
DIVIDE
  (CurrentTotal 
  ,AllTotal
)

Something like this ^

[Michaelkuesten]

Thank you so much @ray_ux 
I'm going to try