Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display table that fulfills filter?

Hello!
I want to display a table with names and dates that fulfills certain requirements. 
I am stuck. It's probably the easiest thing in the world.
I have a slider:

And I have a factTable:

And I want show the rows where the OD is the same as the slider. 
How would you do that?

Sincerely,

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a measure like below.

    measure = if(selectedvalue('facttable'[OD])=selectedvalue('slider'[parameter]),1,0)

    Then add this measure to visual filter where measure =1.

     

    Best Regards,

    Jay

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    And I cant just make a relationship because I will need to find all that are within XX% of the OD later. Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Create a measure like below.

    measure = if(selectedvalue('facttable'[OD])=selectedvalue('slider'[parameter]),1,0)

    Then add this measure to visual filter where measure =1.

     

    Best Regards,

    Jay