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
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        It's done, I sent it to you