cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Totals looking worse than individual, as "mix" has changed

Hi all,

 

I have an issue showing performance.

 

We have some customers where we have worked to increase our margins (cm).

 

companyissue.png

OI Base: Shows our revenue before we changed "settings" to improve margins

Contr Base: Shows our contribution before we changed "settings" 

CM Base: Shows our Margins before we changed "settings".

OI change: Revenue after new settings

Contr change: Contributions after new settings

CM Change: Margins after new settings

CMDiff: Difference between the 2 CMs

ExtraEarnings: OI Change * CM Diff

 

As you can see for each individual customer our Margins is better and "extra earnings" is positive for each.

 

However for totals (as our Revenue mix has changed between the customers) it is negative numbers.

 

I would like to just show 7776 + 922 as "extra earnings". but because the mix has changed, the totals are looking worse.

 

Help!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Totals looking worse than individual, as "mix" has changed

Hi @PeterStuhr ,

 

For the Extra Earnings you need to do a similar measure to this:

ExtraEarnings =
IF (
    HASONEVALUE ( Table[Company] ),
    [OI Change] * [CMDiff],
    SUMX ( ALLSELECTED ( Table[Company] ), [OI Change] * [CMDiff] )
)

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Totals looking worse than individual, as "mix" has changed

Hi @PeterStuhr ,

 

For the Extra Earnings you need to do a similar measure to this:

ExtraEarnings =
IF (
    HASONEVALUE ( Table[Company] ),
    [OI Change] * [CMDiff],
    SUMX ( ALLSELECTED ( Table[Company] ), [OI Change] * [CMDiff] )
)

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors