Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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

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?

 

saikrishnan_0-1653755190044.png

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anonymous 

Please check the attached file below my signature for the measures

Fowmy_0-1653765972074.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@Anonymous 

Please check the attached file below my signature for the measures

Fowmy_0-1653765972074.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.