Excluding that specific row amount from total amount from every single row calculation

[saikrishnan]

Hello Group,

I have an issue where I need to calculate overall profitability impact if I exclude that single product and in Excel it was easy but I need it as a visual in Power BI?

In below screen shot, I need help on DAX on columns highlighted where In if Product A Net revenue is excluded from Total Revenue what would be my impact on overall profitability.

Now I need that for each single row calculation where Prod B,C,D etc excluded and calculate its Impact?

Please help on DAX calcualtion in regards to it?

[Fowmy · Accepted solution]

@saikrishnan 

Please check the attached file below my signature for the measures