Incorrect matrix subtotal

[ABC11]

Hi,

Instead of sum I amgetting max value in subtotal in my matrix. Anyone can help me here.

I am doing following sum of calculation for LINENUM distinctcount.

sum Count of LINENUM = sumx(values(LEM_STATUS_ALL_V[WAPPRDATE].[Date]),

CALCULATE(

    DISTINCTCOUNT('LEM_STATUS_ALL_V'[LINENUM]),

    'LEM_STATUS_ALL_V'[LEMNUM]

))

Thanks

ABC1

[tamerj1 · Accepted solution]

Hi @ABC11 

you may try 

sum Count of LINENUM =
SUMX (
    SUMMARIZE (
        LEM_STATUS_ALL_V,
        LEM_STATUS_ALL_V[WAPPRDATE],
        LEM_STATUS_ALL_V[WAPPRBY],
        LEM_STATUS_ALL_V[SUBMITBY]
    ),
    CALCULATE (
        DISTINCTCOUNT ( 'LEM_STATUS_ALL_V'[LINENUM] ),
        'LEM_STATUS_ALL_V'[LEMNUM]
    )
)

[ABC11]

Thanks Tamerj1.

Its worked