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

Finnaly found with this formula

% of Grand Total =
DIVIDE (
    SUM ( Table1[Values] ),
    CALCULATE ( SUM ( 'Table1'[Values] ), ALL ( 'Table1'[brands] ) )
)