Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Value

Hai Guys Need help on this. Requirement I Have a Year slicer and a group slicer( Two slicers) year slicer are have the different years from 2018 to 2022 In the target table, the year column only h...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    You can use isfiltered

     

    and create a measure like

     

    Switch (True() ,

    selectedvalue(Table[Year]) =2022 && not calculate( isfiltered(Table[Group]), allselected()) , 0 ,

    not calculate( isfiltered(Table[Group]), allselected()) , 10

    Sum(Table[Target])

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    I tried to create a sample pbix file like the attached.

     

     

    Target based on a condition: =
IF (
    HASONEVALUE ( Data[Group ] ),
    SWITCH (
        TRUE (),
        ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), SUM ( Data[Target] ),
        NOT ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), 0,
        10
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like the attached.

 

 

Target based on a condition: =
IF (
    HASONEVALUE ( Data[Group ] ),
    SWITCH (
        TRUE (),
        ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), SUM ( Data[Target] ),
        NOT ISFILTERED ( 'Group'[Group ] ) && ISFILTERED ( 'Year'[Year] ), 0,
        10
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I Got The solution from your Logic Thanks For your help Jihwan