Forum Discussion

ABC11's avatar
ABC11
Resolver I
4 years ago
Solved

Incorrect matrix subtotal

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(value...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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]
    )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

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]
    )
)