Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure value will filter measure in visual

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)   S...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

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.