Forum Discussion
Using what-if parameter at row-level
Hi, sure, my actual use case can be sumed up with this sample data, then I can extrapolate :
Order;value
Order1;23
Order2;45
Order3;12
Order4;34
(sorry, the forum does not let me use tables for some reason, I get an "invalid HTML" error)
I also created a simple measure:
Orders = count('Table'[Order])
And a parameter :
Anomaly threeshold = GENERATESERIES(0, 50, 1)
I managed to do this in a table by using a measure :
Profitable order? = SELECTEDVALUE('Table'[Sales value])>'Anomaly threeshold'[Anomaly threeshold Value]
But I would also be able to uses this as a column for these use cases
-Use as a filter (ex: show a table with only the orders below/above this dynamically set value)
-Use as a color legend in a pie or bar chart with the repartition of my orders (below or above this value)
But I am not sure this is doable.