Dax Calculation in Selectedvalue function

[Anonymous]

Hi,

i have a requirement, 2 columns,  Year column and Status column 
in silcer1(Year)  when i select 2021 then Slicer2(Status)  dropdown values should appear only 1 dimesnion as "1.Processed"
in silcer1(Year)  when i select 2022 then Slicer2(Status) dropdown should appear only 2 dimesnion as "1.Processed" &"2.Forwarded"

How can i achieve this by using any Dax measure/column? Any suggestions please

[tamerj1]

Hi @Anonymous 
You can place the measure in the filter pane of the slicer. Select "Is not blank" then apply the filter.

[Anonymous]

No Based on Selection in the slicer the values in the Slicer 2 should filter out dynamically
i thinki need to create a measure to achieve this by using selectedvalue dac function? 
what is the DAX measure? any help 

[tamerj1]

@Anonymous 
The first slicer filters the measure and the measure filters the 2nd slicer

[Anonymous]

what is the dynamic DAX measure for this ?

[tamerj1]

@Anonymous 
Good question. In irder to answer that I need information about your data model and relationships.