Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dax | Data modeling issues

Hello everyone, I have an issue with my model and how to extract data from it using the relations between my tables. My final output is from the key from Dim1, I'll use it to extract all columns fro...
Data Protection
MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous,

 

When you refer you want to extract all the columns from FACT 2 what do you mean is it a table visualization, is it another table on your model?

Can you please elaborate on the expected result and an example of what you want to have?

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have a four tables in my model( two diemnsion tables, 2 fact tables) linked to each other, in generam I want from my dimension table dim1, search by key and get back all the columns in my data table which is fact 2, as I said, I will search by cl1 of Dim1 in Fact1, and then by CL1, Ill get the CL2 keys from Fact 1 also to search for it in Dim2, and by the end, Iwill take the CL3 from the Fact2 by the CL2, and the final output is the columns from my Fact2, I want a dax code to do that, and in my visual side, I wanna display CL1 from Dim1 with all columns from Fact2

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi Anonymous ,

     

    Create the following measure:

    Show Values = CALCULATE(COUNTROWS(Fact2), CROSSFILTER(Dim2[ID2], Fact1[ID2], Both))

    Now add this measure as part of your table visual as you can see in the example below the data gets filtered:

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello, can I talk to you in private or anytihing to get more informations about that if you can

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Sure, send  private message throug the forum.