Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Simple IF STATEMENT asap

Hi, Real quick one here. I have a Measure, that calcualtes what you see under here. Some on the values are blank. I want to aadd in a if statement. TEST A = help here: IF VALUE OF THIS ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    Maybe you can try to use the measure if it works on your side:

    Test =
IF (
    [Measure1] <> BLANK (),
    [Measure1],
    CALCULATE (
        MAX ( 'DATASET A'[Volume p1] ),
        FILTER ( ALLSELECTED ( 'DATESET A' ), 'DATA SET A'[Dato/tid] = [Max date/time] )
    )
)

    If above not help, please share some sample data so that we can test to coding formula on it.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Maybe you can try to use the measure if it works on your side:

Test =
IF (
    [Measure1] <> BLANK (),
    [Measure1],
    CALCULATE (
        MAX ( 'DATASET A'[Volume p1] ),
        FILTER ( ALLSELECTED ( 'DATESET A' ), 'DATA SET A'[Dato/tid] = [Max date/time] )
    )
)

If above not help, please share some sample data so that we can test to coding formula on it.

 

Regards,

Xiaoxin Sheng