Forum Discussion

kingchad5's avatar
kingchad5
Icon for Helper I rankHelper I
8 years ago

What If Parameter used to filter visualization

I am trying to use a what if parameter to dynamically filter a visualization.  I have a parameter table for the probability of a sale for opportunities.  I have a slicer to choose what chance of clos...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

"Calc. Column   Probability Display" -> This should be measure

 

Calc. Measure Probability Display = 
IF(MAX(wh_opportunity[Probability Decimal]) >= [Probability Value],1,0)

use this as visual level filter where = 1

kingchad5's avatar
kingchad5
Icon for Helper I rankHelper I
8 years ago

Thanks for your reply,

 

I tried this and I am getting the same results.  Wouldn't MAX(wh_opportunity[Probability Decimal]) compare the max Probability Decimal of the column vs. the probability value?  The max decimal is .90.  

 

Chad