Total result of a measure with IF

[Aurore]

Hello,

I'm having some issues displaying the total result of a Measure with IF statment.

I have this column, based on the following measure:

VAL_BASE_CALC_SERV_PREST =

VAR bcsp = [VAL_MAX_CONTRIB] - [VAL_BASE_OF_II]

RETURN CALCULATE((IF(bcsp > [VAL_SERV_PREST],[VAL_SERV_PREST],

                  IF(bcsp <= 0,0,(bcsp)))))

The total row is showing me "0,00" but I need to show me the result of the values. I tried creating another

measure to sum the values, but it give-me 0 too.

Best Regards

Daniel.

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below whether it suits your requirement.

VAL_BASE_CALC_SERV_PREST =
SUMX (
    VALUES ( 'table_name'[culumn_name_in_the_visualization] ),
    IF (
        [VAL_MAX_CONTRIB] - [VAL_BASE_OF_II] > [VAL_SERV_PREST],
        [VAL_SERV_PREST],
        IF (
            [VAL_MAX_CONTRIB] - [VAL_BASE_OF_II] <= 0,
            0,
            ( [VAL_MAX_CONTRIB] - [VAL_BASE_OF_II] )
        )
    )
)