Forum Discussion
Quick Measure Filters: how do I use dynamic filter for "Percentage difference from filtered value"?
Hello!
How do I convert this to a dynamic selection instead of a pre-selected one?
As an example, depending on what is selected on the graph on the left, "West" or "South", etc., would be the baseline value, and the graph on the right would update accordingly.
I would appreciate any help.
2 Replies
- amitchandak
Super User
Anonymous ,If should be like
if( max(Table[Team]) in {"West" , "South"} , calculate([retun value], Table[Team] ="North"), [retun value])
amitchandak I appreciate your suggestion, but I do not follow it.
The right graph should change depending on the group highlighted/clicked on the left.
VAR __BASELINE_VALUE = CALCULATE([Return_rate], 'sheet1'[Team] IN { selected_group})Example: if "South" is clicked on the left then graph updates to selected_group="South". If next, "North" is clicked then the graph should update to selected_group="North"
