Joining of id's and getting the text

[Anonymous]

Hi Team,

I am new to power Bi . Please help me in solving the issue

I am having a dimension table and Fact table . where i need to map the two id's from a fact table to dimension table and get the Descrption.

In this image i need to join Dw_input_Type_id with Dw_type_id and get descrption from Type_Desc_text .

In the same way i need to join the Dw_Olet_Type_id with the Dw_Type_id and get descrption from Type_Desc_text

The Type_Desc_text hold the data of both Input Type(Dw_input_Type_id ) and Outlet Type(Dw_Olet_Type_id)

Can any one please help  me in creating the dax to achieve the above requirement

[ibarrau · Accepted solution]

Hi, it is confusing if there a description for each id input or olet.

If you need to calculate a single number you can create a measure to take care an inactive relationship to manage one arrow and other measure for the other arrow.

If  you want the description text in the fact table. Create a duplicate dimension and join each one with a different id. Then you can create a calculated dax column in fact table like this:

Description_Olet = RELATED ( Dimension_Olet[DescriptionField] ) 

If this doesn't help please explain more about the requeriment.

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.