Savings upon saving

DAX DAX Calculations
3

Hello @nico.swartz,

Thank You for posting your query onto the Forum.

Is this the result that you’re looking for? Below is the screenshot provided for the reference -

Dependant Calculation

So at first I considered that in the case of “Gross Consumption” all the projects will consume the same no. of units. And then accordingly as per the conditions that you’ve stated I’ve deducted 10% from every subsequent projects. Below is the formula provided for the reference -

Gross Consumption = Gross Consumption = SUM( Projects[Consumption] )

Net Consumption = 
VAR ProjectA = [Gross Consumption] - ( [Gross Consumption] * 0.1 )

VAR ProjectB = ProjectA - ( ProjectA * 0.1 )

VAR ProjectC = ProjectB - ( ProjectB * 0.1 )

VAR ProjectWiseConsumption = 
SWITCH( TRUE() , 
    SELECTEDVALUE( Projects[Projects] ) = "A" , ProjectA , 
    SELECTEDVALUE( Projects[Projects] ) = "B" , ProjectB ,
    SELECTEDVALUE( Projects[Projects] ) = "C" , ProjectC , 
ProjectA + ProjectB + ProjectC )

RETURN
ProjectWiseConsumption

And then in order to get the correct grand totals. Below is the formula used to retrieve correct totals -

Net Consumption (Correct Totals) = 
SUMX(
    SUMMARIZE( Projects , Projects[Projects] , "Correct Totals" , [Net Consumption] ) , 
[Correct Totals] )

I’m also attaching the working of the PBIX file of the working for the reference. Also providing a link below of the post which was created by one of our expert member @Greg which is based on “How To Fix The Incorrect Totals”.

Hoping you find this useful and meets your requirements that you’re looking for. :slightly_smiling_face:

Please Note: If this is not the case, then as suggested by @Melissa please provide the working of the PBIX file alongwith the desired results that you’re looking for.

Thanks and Warm Regards,
Harsh

Dependant Calculation.pbix (35.5 KB)

Dependant Calculation.xlsx (17.8 KB)

Note: In order to view the entire post, please click onto the link and not onto the “Expand/Collapse” button.