Forum Discussion
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...
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 Thank you it worked!
dokat Glad to hear that.