Create a measure that sum higher level basing of the sum of the lower

[Soniar]

I need to sum a value that is calculated at a lower level.

I created a measure that calculate a difference in sls by customer and the result is:

customer F06360= 0 

customer F23334 = 36,12

and this is the measure:

newcus LY difference = calculate(IF(ISBLANK(MAX('NEWCUS LY'[Cod. Movex ])),0,

if([SALES YTD]- SUMX('NEWCUS LY',[SALES LY])<0,0,[SALES YTD]- SUMX('NEWCUS LY',[SALES LY]))))

then in my matrix visual I aggregated these 2 values by salesman(FE21) but the result is 0 instead of 36,12

any idea? Sales are correctly sum but not my measure

thanks

Sonia

[Anonymous]

Hi, @Soniar 

You can provide pbix files without sensitive data for testing purposes.

Best Regards,
Yang
Community Support Team

[Soniar]

I solved with 2 meausures i/o 1. thanks