Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change Measure based on Slicer Value

I have a table that contains YTD, MTD, WTD, and 2019

 

I want to write a formula that when the user selects YTD, MTD, or WTD on the slicer it displays the measure 2020 Outlet Status, when a user selects 2019 on the Slicer is displays another Measure 2019 Outlet Status. 

 

Basically I just need 

IF('Period Select'[Period Select]= "2019"

then [2019 Outlet Status]

ELSE [2020 Outlet Status]

END

 

Im having an issue becuase I am not calculating anything- its just classifying outlets. 

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 
    If MTD YTD WTD and 2019 are 4 columns, you would need to create a new slicer table name it as slicer column.

     

    Measure = IF(SELECTEDVALUE('Slicer Table'[Slicer Column])="2019",[2019 Outlet Status],[2020 Outlet Status])

     

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies