Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax Calculation in Selectedvalue function

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

DAX

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        tamerj1
        Community Champion
        3 years ago

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