Forum Discussion

Notakker's avatar
Notakker
Regular Visitor
3 years ago
Solved

Filter common values

My data: My goal: I'm trying to build a graph with Users and common values between them (at least two). Example, when I try to build my graph, thats what I have: But I want to eliminat...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Notakker 

    You can refer to the following measure

    Measure = IF(COUNTROWS(FILTER(ALLSELECTED('Table'),[Related]=SELECTEDVALUE('Table'[Related])))>1,1,0)

    Then put the measure to the visual filter

    It can work

     

    Best Regards!

    Yolo Zhu

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Notakker 

You can refer to the following measure

Measure = IF(COUNTROWS(FILTER(ALLSELECTED('Table'),[Related]=SELECTEDVALUE('Table'[Related])))>1,1,0)

Then put the measure to the visual filter

It can work

 

Best Regards!

Yolo Zhu

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