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 it worked!
vojtechsima
Super User
Super UserAnonymous Glad to hear that.