cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sum measure from result of sum of previous measure

Hi,

 

I have an urgent issue I hope someone can solve.

 

I have 4 tables in a tabular model that are related; Customer, Product, Sales Forecast, Sales Order Line.

All link with either Customer, product or a combination of both.

 

I have a calculation that is IF(SUM(Sales Order Line Qty - Sales Forecast Qty)<=0,0,SUM(Sales Order Line Qty - Sales Forecast Qty)) this is at product level.

 

I want to sum the result of this calculation to customer level, as the customer may have one or more products.

Just summing at Customer level gives the wrong amount. This is because a customer may have been supplied a product that has not been forecast and vice versa. 

 

So in summary, sum the result from the lower level sum.

 

I think I am overthinking this lol.

 

Regards

Mark

 

 

2 REPLIES 2
Anonymous
Not applicable

I solved the problem by creating a sumx over a cross joi.

Anonymous
Not applicable

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors