Forum Discussion
LinhNguyen
Helper II
7 years agoMeasure value based on selection
Hi everyone, I'm trying to create a dynamic filter value based on slicer selection. In table 'Bonus Selection', I only have 1 column with "Yes" and "No" as value. I created a single selectio...
LinhNguyen
Helper II
7 years agoI want to get that measure so that I can do a filter based on the viewer's choice. When the users choose "No", I want to filter out one particular cost element ID, which is the value returned in the formula earlier. I can place a filter on the whole page, lock and hide it so that no one can see.
With that said, creating the same measure in the Bonus selection table might help too. However it's a blank value even when I create that measure in the Bonus Selection table.
LinhNguyen
Helper II
7 years agoI tried using calculated column as well but that didn't work either