cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mason23 Frequent Visitor
Frequent Visitor

Getting the difference between to measures

Hi folks,

Is it possible to subtract between measures?

I have two measures Revenue and TotalExpenses showing as "card" . I'm looking to get the net income by using this formula

Net Income = Revenue - TotalExpenses

 

 

 

Thank you!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Getting the difference between to measures

If those two are really measures the your [Net Income] measure would be:

Net Income = [Revenue] - [TotalExpenses]

 

4 REPLIES 4
Super User
Super User

Re: Getting the difference between to measures

If those two are really measures the your [Net Income] measure would be:

Net Income = [Revenue] - [TotalExpenses]

 

LW Member
Member

Re: Getting the difference between to measures

Net Revenue= 
SUMX (<Table>,
           <Revenue Measure> - <TotalExpenses Measure> 
           )

Thanks @mason23 

mason23 Frequent Visitor
Frequent Visitor

Re: Getting the difference between to measures

Thank you all fo your replies. I'll try it out and will update the result. 

mason23 Frequent Visitor
Frequent Visitor

Re: Getting the difference between to measures

Hi

This formula works. Thank you!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 45 members 988 guests
Please welcome our newest community members: