Forum Discussion

dokat's avatar
dokat
Post Prodigy
4 years ago
Solved

Share Calculation

Hi,   I'd like to calculate share based on Region Sales divided by total sales. I created below table by removing interactions between slicer and the table. Sum of my sales values are $2,535,250,04...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    dokat 
    Sure, you either use ALL([Column1], [Column2], [Column3], [Column4]) or you can mention columns that you want to keep filtered ALLEXPECT([Column6]) for example.

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, dokat ,
If you just add:
ALL([Your Slicer Table Column]
as one of the filters in your CALCULATE expression. It will ignore any filtering applied by this column.

So try playing with something like this:

Region Test Measure2 = CALCULATE(Calculate(SUM('Region'[Values]),ALL([Your SlicerTable Column],'POS CY'[Slicer] IN {"L52W"}))


 

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    vojtechsima @Thank you for your response. I have 4 slicers, is there a way to expand this formula to include all slicers?

    • vojtechsima's avatar
      vojtechsima
      Super User
      4 years ago

      dokat 
      Sure, you either use ALL([Column1], [Column2], [Column3], [Column4]) or you can mention columns that you want to keep filtered ALLEXPECT([Column6]) for example.

      • dokat's avatar
        dokat
        Post Prodigy
        4 years ago

        vojtechsima Thank you it worked!