Forum Discussion
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...
Anonymous
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 @Thank you for your response. I have 4 slicers, is there a way to expand this formula to include all slicers?
vojtechsima
Super User
Super UserAnonymous
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 Thank you it worked!
- vojtechsima
Anonymous Glad to hear that.