Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago

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

Group YearTarget
India20223
Japan20223
Russia20223
Ukraine20223
UK20222
FRANCE20223

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.




Need Help
Show and Tell

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

     

    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
    )
)
    • AlanP514's avatar
      AlanP514
      Post Patron
      4 years ago

      Hai Jihwan Kim Thanks For the Solution.
      But the requirement is something Different I will show you with mock data.

      Target Table  
      Group YearTarget
      India20223
      Japan20223
      Russia20223
      Ukraine20223
      UK20222
      FRANCE20223

      Above attached is my target table.
      And Below i am attaching requirement please help me


      Thanks