Dynamic Value

[Anonymous]

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 has 2022 values, and different groups like this

Group	Year	Target
India	2022	3
Japan	2022	3
Russia	2022	3
Ukraine	2022	3
UK	2022	2
FRANCE	2022	3

One condition > My manager wants to see if he doesn't select any filter(slicer) he wants to see a static value "10" otherwise that particular group value. 
2nd Condition > If he directly selects 2022 or any year without group slicer he wants to see the static value "0 ".
But He wants to see the actual target value when he selects that particular year with a particular group only
Please help with this.

[amitchandak · Accepted solution]

@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 · Accepted solution]

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]

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

[amitchandak · Accepted solution]

@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])