Measure value will filter measure in visual

[Anonymous]

Hi, Is there an easier way to this. Let's say I have a measure called checker and have a simple table visual which includes columns from a table called example (columns: name and user activity)

So basically if checker is equal to 1, the user activity equals all values. While if it is 0, the user activity only equals "Active"

I made a measure as a placeholder for the user activity:

Active checker =

var activevalue = Values(example[user activity])

RETURN

IF([checker]=1,activevalue,user activity should only be "active")

Can anyone help me, I've been stuck with this measure for quite some time now. Thank you.

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous So like this?

Active checker =
IF([checker]=1,"All","Active")

[Anonymous]

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.

[Anonymous]

That technically is not filtering the table I want to filter, since there is connection between the measure and the visual table columns

[Greg_Deckler]

@Anonymous That greatly depends. You haven't provided any sample data or how your visual is configured so it's impossible for me to know. I use this technique all the time, it is called a Complex Selector: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534