Forum Discussion

likmalik's avatar
likmalik
Icon for Helper I rankHelper I
5 years ago
Solved

Filter a graph without changing grand total value

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 countri...
Need Help
  • likmalik's avatar
    likmalik
    5 years ago

    Finnaly found with this formula

    % of Grand Total =
DIVIDE (
    SUM ( Table1[Values] ),
    CALCULATE ( SUM ( 'Table1'[Values] ), ALL ( 'Table1'[brands] ) )
)
likmalik's avatar
likmalik
Icon for Helper I rankHelper I
5 years ago

Please someone can help me ? I have the same problem with lines where I want to follow the MS evolution month by month but the percentage is not made on the total value. 

 

This is the difference between what I want to get ( works on excel) and powerbi. Percentage are not the same.