Forum Discussion

extrasiyf's avatar
extrasiyf
Frequent Visitor
5 years ago
Solved

How to create relation with 2 slicers

Hello, 

I want to create a relation with 2 slicers from 2 differents tables, the problem is that I have 2 columns, so I cannot use the SelectedValue like a measure. 

Any solutions ? 

 

 

Data Protection
Need Help
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi extrasiyf ,

    You can use DISTINCT() to extract one of your columns as a new table without any relationships between your source table. Then you can use SELECTEDVALUE() to do some calculation when selecting field in the slicer.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • extrasiyf's avatar
      extrasiyf
      Frequent Visitor
      5 years ago

      amitchandak To just select one slicer not both. Because I have two departments for 2 differents table with the same data. Can i just refer to one slicer with Dax ? 

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi extrasiyf ,

        You can use DISTINCT() to extract one of your columns as a new table without any relationships between your source table. Then you can use SELECTEDVALUE() to do some calculation when selecting field in the slicer.

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.