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.
Hello,
The challenge here consists of finding the difference between the measures below:
Overview Table
Product | Cost | Plant |
Item1 | 1.00 | Plant A |
Item1 | 2.00 | Plant B |
Item2 | 2.50 | Plant A |
Item2 | 2.30 | Plant B |
Cost Table
Product | Cost |
Item1 | 1.10 |
Item2 | 1.90 |
Item3 | 2.30 |
Hi, @Asantos2020
And you want have the difference between costs for a product, what about the Plant A or B.
Could provide the pbix if possible, so I can create something similar to yours and help your out.
Best,
Paul
Hello @V-pazhen-msft !
I would then need to find the differences between:
Cost ERP = SUM(Cost Table[Cost])
and
@Asantos2020
I find no problem with the difference with the sample I created based on your original post.
Please create a sample pbix that similar to your dataset, including the related columns and relationship between tables,
Paul
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.