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 Team,
Need your support on this below issue.
I have two different tables in my model (stocks, delivery). I want to do some calculations for purchase, production, and delivery.
For delivery, already I have written all my calculations DAX and it is working properly in separate delivery report page and I would like to use all those calculations in this stocks report page as well. However, the values are not changing in my stocks page.
I have made many-to-many relationship with “movement type” field between these two tables and tried with “both” and “single” cross filter option but I am not getting desired results in my report page.
Please check the image below, I am choosing “Production” category but still it’s showing Delivery values whereas it should show only for “Delivery” category. Please advise how to achieve this.
Solved! Go to Solution.
This issue has been fixed, i have Calculate table applied some group by function over the delivery status table. I have made relationship with this calculate table and it's working fine. Thanks!
This issue has been fixed, i have Calculate table applied some group by function over the delivery status table. I have made relationship with this calculate table and it's working fine. Thanks!
Hey,
Im on a pretty small screen right now, but that relationship looks like it is inactive. Could you try and make the relationship active?
Quality over Quantity
@EricHulshof: Relationship is active only, i have verified it again. Still it's not working..
@DivakarKrishnan Hmm, could you maybe send me a Power BI report with the problem? Then i can take a closer look at it.
Please make sure their is no confidential data in the report.
Quality over Quantity
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |