Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
3 years ago

MAX Measure calculating total & additional rows in Matrix

I have created a MAX Measure..   MAX Measure = MAXX(ALLSELECTED('Sales Header'[Sell-to Customer Name]),[Sales Line Amount])   Which is working fine as it is catching the max value of all the quo...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Tob_P 

please try

MAX Measure =
IF (
    NOT ISEMPTY ( VALUES ( 'Sales Header'[Sell-to Customer Name] ) ),
    MAXX (
        ALLSELECTED ( 'Sales Header'[Sell-to Customer Name] ),
        [Sales Line Amount]
    )
)