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.

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.