The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I ve a table with the comsuptions by prodution order and then the drilldown by material.
I want to calculate the amount in euros of the difference between the real and teorical consumptions.
The delta (in units and euros are correct). But the total of the delta in euros at order level not (should be the sum of the material differences).
The data have the following structure:
One table with the real consumptions by production order and material;
One table with the teorical consumptions by production order and material;
Another table with price of each material in euros;
The measure that I want to fix is:
Any suggestion?
Solved! Go to Solution.
Hello @Jomachado1 ,
You can use SUMX to bring the row context in the calculation, please try the below measure..
Delta in euros =
SUMX('Material Table',
CALCULATE(SUM('Price Table'[Unit Price]) *
(SUM('Real Consumption Table'[Consumption]) - SUM('Theoretical Consumption Table'[Consumption]))))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Hello @Jomachado1 ,
You can use SUMX to bring the row context in the calculation, please try the below measure..
Delta in euros =
SUMX('Material Table',
CALCULATE(SUM('Price Table'[Unit Price]) *
(SUM('Real Consumption Table'[Consumption]) - SUM('Theoretical Consumption Table'[Consumption]))))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Thanks Dharmendar for the quick response.
The soluction propose works perfectely!
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |