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.

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!