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 h...
Need Help
Show and Tell
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