Forum Discussion
Solved
Dynamic Column Calculation Based on Multiple Slicers
I have a table of sales opportunities, and I want to create a column which displays the ratio of the opportunity's value compared to all active opportunities. I was able to accomplish this with the f...
Hi kolson256,
According to your description, using ALLSELECTED Function (DAX) should meet your needs. The formula below is for your reference.:smileyhappy:
RATIO = SUM ( Table1[Amount] ) / CALCULATE ( SUM ( Table1[Amount] ), ALLSELECTED () )
Regards
In this case ALLEXCEPT will help u.
u have to understand the difference between ALL, ALLSELECTED, ALLEXCEPT.
your calculation is almost correct dude, have one simple correction .
u have to add ALLEXCEPT and apply what every column u want.
thats it.
cool