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(values(LEM_STATUS_ALL_V[WAPPRDATE].[Date]),
CALCULATE(
    DISTINCTCOUNT('LEM_STATUS_ALL_V'[LINENUM]),
    'LEM_STATUS_ALL_V'[LEMNUM]
))

 

Thanks

ABC1

 

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

2 Replies

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