Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Selected Value DAX

Hi,   I have two tables : Example -    Table 1 -                         Table 2 -    Key       Test                       Key       Production     A           Version 1                D       ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    This is what I want to suggest

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Create a common dimension Test and join with both tables

 

Test = distinct(Table1[Test])

 

And join with both the tables. Use this in slicer or page level filter

Join Test[Test] - Table1[Test]

and join Test[Test] - Table2[Production]

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amit,

     

    sorry I don't understand. How do you propose I join the two tables? 

    The first is a measure and I cannot join it with a table.