Forum Discussion
Measure value will filter measure in visual
Hi Anonymous ,
According to your description, when the measure checher is 1, you want to filter the visual for user activity to show active rows only. Here's my solution.
Create a measure:
Flag = IF ( [checker] = 1 && MAX ( example[user activity] ) = "active", 1, 0 )Put the measure in the visual filter and select its value to1.
After apply filter, get the result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionAnonymous So like this?
Active checker =
IF([checker]=1,"All","Active")Yes, but that will just return a measure value of "all" or "active", I want to filter the measure that acts like a column based on what the values are. I'm not sure if that's doable or a measure acting as a filter is doable in a table visual containing columns from a table.
- Greg_Deckler
Anonymous Just put your measure in your Visual Filters in the Visual pane and filter for either "All" or "Active". For that matter, you could use your checker measure that way.
That technically is not filtering the table I want to filter, since there is connection between the measure and the visual table columns