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...
DAX
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
    Icon for Community Champion rankCommunity Champion
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      what is the dynamic DAX measure for this ?

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

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