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)

 

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.
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.

     

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous So like this?

    Active checker =
IF([checker]=1,"All","Active")
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community 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.