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.
I have a matrix built out based on the red relationship (comprised mostly of information from the left tabel). I would like to create a another matrix, this one containing all the columns in the left table. I want this matrix to be filter to show all "Development" based on the item selected in the original matrix. I have found no combination of CALCULATE, USERELATIONSHIP, ALL and ALLEXCEPT to get the disered resutls to return.
Intuitevly, I thought the line below would work. I would load the columns form the left table into a matrix and add this measure:
= CALCULATE(MAX(LeftTable[Actual_date]),USERELATIONSHIP(LeftTable[Development],RightTable[Development]),ALLEXCEPT(RightTable,RightTable[Development]))
Hi @klintala ,
Would you please inform us more detailed information( your
data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai
@klintala Many to Many relationships are complex, as is both cross filter direction. Are you able to provide more context for your data (sample data if possible) and why there is a many to many relationship. Because of this, we need to know exactly what result you are expecting, as there won't be simply one choice for the meausre result. How do you want the results aggregated?
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
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |