measure as an argument in another measure

[12Bowers12]

Hello everyone,

Sorry I could not figure out  the format requirement.

I have two measures, Premium and Loss. If Premium is zero, Loss should be zero, How can I use measure Premium as an argument in measure Loss?

Thank lot.

Dennis

Loss =

VAR Prem = [Premium]  

RETURN

    CALCULATE (

        SUM ( Data[Loss] ),

        Prem > 0

    )

[tyatsenko]

Hi,

Try this one:

Loss =

VAR Prem = [Premium]  

RETURN  IF(Prem =0, 0,

    CALCULATE (

        SUM ( Data[Loss] )

    )

[_AAndrade]

Try this: IF([Premium]=0, 0,SUM ( Data[Loss] ))