Forum Discussion

likmalik's avatar
likmalik
Helper 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] ) )
)
amitchandak's avatar
amitchandak
Super User
5 years ago

likmalik , Try a % measure like


My Measure = divide(My Measure = CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31))), CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)), all(Sheet1)))

 

or


My Measure = divide(My Measure = CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31))), CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)), allselected(Sheet1)))

likmalik's avatar
likmalik
Helper I
5 years ago

Hello and thankyou amitchandak but I don't know why but it didn't work