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.
Dear Community,
Hope you're doing ok! I have the following problem. I would like to have a matrix visualization, where the rows has to show BU (Buiness Unit) and the Columns to show risk code (after that i will add the values).
However, when i do it i got the following message, which i understand as i don't have relationship between both tables (both of them used as primary keys).
Here's my data model below. I tried to make the Risk code and Agings relationship "both". Same with the BU and BU lookup table, but doesn't seem to work. Can you please help me establish relationship between the 2 tables?
All due repect,
Atanas
Solved! Go to Solution.
ah, interesting one. You may need to add the values before it will recognize the relationship, which in your data model is a tricky relationship as it goes through the BU and SalesInvoiceNumber tables, so depending on what your value is, and if the cross filter directions and relationships work with that value.
Try adding this measure to the values and see what happens as a starting point:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
ah, interesting one. You may need to add the values before it will recognize the relationship, which in your data model is a tricky relationship as it goes through the BU and SalesInvoiceNumber tables, so depending on what your value is, and if the cross filter directions and relationships work with that value.
Try adding this measure to the values and see what happens as a starting point:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
When added the values it worked!
Thank you so much Allison!
Take care,
Atanas
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |