Dax | Data modeling issues

[Anonymous]

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 from the Fact2.

My idea was into steps : 

1. Search in fact table for the key column(CL1) of Dim1.

2. By the CL1 in Fact tables, get back the (key column)CL2 also from the same table.

3. Using CL2 to go through Dim2 and search for (key column)CL3. 

4. Using CL3 to get back the final output which is the data from our final fact tables.

This is my imagination about how to illustrate the Dax code, but I was having some problems how to write it. If please can someone help me and thank you so much.

[Anonymous]

Hi @Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[MFelix]

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]

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]

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]

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

[MFelix]

Sure, send  private message throug the forum.

[Anonymous]

It's done, I sent it to you