combining measures into one?

[Anonymous]

I have 7 measures spread over 7 columns and I am aiming to merge them into one…

By using local variables (VAR) and ISINSCOPE, I should be able to display the same results, right?

The measures I have are:

TotalPerCustomer =

CALCULATE ( SUM ( Sheet1[NSR] ), ALLSELECTED (), VALUES ( Sheet1[CUST] ), Sheet1[NSR]>0 )

MaxBUPerCustomer =

CALCULATE ( MAX ( Sheet1[NSR] ), ALLSELECTED (), VALUES ( Sheet1[CUST] ) )

MDMCustomer =

[TotalPerCustomer] / [MaxBUPerCustomer]

TotalPerUP =

CALCULATE ( SUM ( Sheet1[NSR] ), ALLSELECTED (), VALUES ( Sheet1[UP] ) )

SubTotalBU =

CALCULATE ( SUM ( Sheet1[NSR] ), ALLEXCEPT ( Sheet1, Sheet1[UP], Sheet1[BU] ) )

MaxBUPerUP =

MAXX ( ALLEXCEPT ( Sheet1, Sheet1[UP] ), [SubTotalBU] )

MDMUp = [TotalPerUP]/[MaxBUPerUP]

[Anonymous]

Yes, You should be able to do that. Are you facing any issue?

Thanks!