Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Happy to help!
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.
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
56 | |
47 | |
16 | |
12 |