Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Filtering Value With Different Conditions

Hai All Need your help on this please help me. This is my target table attached below Target Table     Group  Year Target India 2022 3 Japan 2022 3 Russia 2022 3 Ukrai...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Target 2 =
    IF (

    || HASONEVALUE ( 'Mapping Area'[Cluster/Function] )
    || HASONEVALUE ( 'Calendar'[Year] ),
    SWITCH (
    TRUE (),
    && ISFILTERED ( 'Mapping Area'[Cluster/Function] )
    && ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] ),
    || ISFILTERED ( 'Mapping Area'[Cluster/Function] ), [FLT],
    ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] )
    ),
    IF ( CALCULATE ( NOT ISCROSSFILTERED ( 'Targets' ) ), [FLT] )
    )

  • Anonymous's avatar
    Anonymous
    4 years ago

    Target =
    IF (

    || HASONEVALUE ( 'Mapping Area'[Cluster/Function] )
    || HASONEVALUE ( 'Calendar'[Year] ),
    SWITCH (
    TRUE (),
    && ISFILTERED ( 'Mapping Area'[Cluster/Function] )
    && ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] ),
    || ISFILTERED ( 'Mapping Area'[Cluster/Function] ), [FLT],
    ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] )
    ),
    IF ( CALCULATE ( NOT ISCROSSFILTERED ( 'Targets' ) ), [FLT] )
    )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Target 2 =
IF (

|| HASONEVALUE ( 'Mapping Area'[Cluster/Function] )
|| HASONEVALUE ( 'Calendar'[Year] ),
SWITCH (
TRUE (),
&& ISFILTERED ( 'Mapping Area'[Cluster/Function] )
&& ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] ),
|| ISFILTERED ( 'Mapping Area'[Cluster/Function] ), [FLT],
ISFILTERED ( 'Calendar'[Year] ), SUM ( Targets[CLT/FLT TARGET 2 STARS] )
),
IF ( CALCULATE ( NOT ISCROSSFILTERED ( 'Targets' ) ), [FLT] )
)