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
You should be able to achieve this by using ALLEXCEPT function
here is more information https://msdn.microsoft.com/en-us/library/ee634795.aspx
Let me know if need further help with the formula. Thanks!