Total of SUMX measure not displaying

[smukherjee]

Hi, I have a SUMX DAX that I am using to do a calculation as below

PRINCIPAL_DIS_ACTUAL =
VAR A =
 SELECTEDVALUE ( V_D_EXCHANGE_RATE[RATE] )
VAR b =
 CALCULATE (
 SUMX ( FILTER (
 V_F_DISBURSEMENT,
 V_F_DISBURSEMENT[PAYMENT_DT] >= MIN ( FROM_DATE[Date] )
 && V_F_DISBURSEMENT[PAYMENT_DT] <= MAX ( DATES[Date] )
 ), V_F_DISBURSEMENT[PRINCIPAL_DIS] * A )
 )
RETURN
 b

Both the columns used in the multiplication are of type decimal. But in the final result in table visualisation the total isn't displayed for the measure as shown below. Any help is appreciated.

[v-janeyg-msft]

Hi, @smukherjee 

Have you tried to use sumx(summarize()) to display total?

Like this:

PRINCIPAL_DIS_ACTUAL =
SUMX (
    SUMMARIZE (
        V_F_DISBURSEMENT,
        [column1]//related column,
        "a",
            VAR A =
                SELECTEDVALUE ( V_D_EXCHANGE_RATE[RATE] )
            RETURN
                SUMX (
                    FILTER (
                        V_F_DISBURSEMENT,
                        V_F_DISBURSEMENT[PAYMENT_DT] >= MIN ( FROM_DATE[Date] )
                            && V_F_DISBURSEMENT[PAYMENT_DT] <= MAX ( DATES[Date] )
                    ),
                    V_F_DISBURSEMENT[PRINCIPAL_DIS] * A
                )
    ),
    [a]
)

If it doesn't solved your problem,please share some sample data and feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

If the Rate column is in your visual, SELECTEDVALUE will return blank in the total row.  You need to use a different expression, or assign a default value for SELECTEDVALUE(Table[Rate], defaultvalue).

Pat