Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested IF condition with ISFILTERED function.

I All, I have written DAX code like this: - Measure = if( ISFILTERED('optimisation'[BROADCASTER]),CALCULATE(DIVIDE ( [1], [2] ), ALL('optimisation'[LEVEL]),'optimisation'[LEVEL] = "BROADCASTER"),...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    You can try below code:-

    Measure =
VAR _series =
    CALCULATE (
        DIVIDE ( [1], [2] ),
        ALL ( 'optimisation'[LEVEL] ),
        'optimisation'[LEVEL] = "SERIES"
    )
VAR _broadcaster =
    CALCULATE (
        DIVIDE ( [1], [2] ),
        ALL ( 'optimisation'[LEVEL] ),
        'optimisation'[LEVEL] = "BROADCASTER"
    )
RETURN
    IF (
        ISFILTERED ( 'optimisation'[SERIES] ),
        IF ( ISFILTERED ( 'optimisation'[BROADCASTER] ), _series ),
        IF ( ISFILTERED ( 'optimisation'[BROADCASTER] ), _broadcaster )
    )

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

You can try below code:-

Measure =
VAR _series =
    CALCULATE (
        DIVIDE ( [1], [2] ),
        ALL ( 'optimisation'[LEVEL] ),
        'optimisation'[LEVEL] = "SERIES"
    )
VAR _broadcaster =
    CALCULATE (
        DIVIDE ( [1], [2] ),
        ALL ( 'optimisation'[LEVEL] ),
        'optimisation'[LEVEL] = "BROADCASTER"
    )
RETURN
    IF (
        ISFILTERED ( 'optimisation'[SERIES] ),
        IF ( ISFILTERED ( 'optimisation'[BROADCASTER] ), _series ),
        IF ( ISFILTERED ( 'optimisation'[BROADCASTER] ), _broadcaster )
    )

 

Thanks,

Samarth

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Samarth_18 Thanks its working.. ğŸ˜Š