Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter table (Multiple Condition) using SELECTEDVALUE from slicer - Please Help!

Hi,   Need help in filtering table using SELECTEDVALUE from slicer.   "data" contains all information Intention is to filter the information from data using the selected value from the slicer  ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like 

    Measure =
var _Table = FILTER(data,data[First Yr of Service]<=SELECTEDVALUE(selected[Year]) && (data[Last Yr of Service]>SELECTEDVALUE(selected[Year]) || data[Last Yr of Service] = blank()))
return
sumx(_table,[Column])
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , You can not use the slicer value in table creation.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your speedy reply. Can you advise what I can do as an alternative?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , There is not alternate you can have this table in measure and use

     

    Measure

    var _Table =
    FILTER(data,data[First Yr of Service]<=SELECTEDVALUE(selected[Year]) && (data[Last Yr of Service]>SELECTEDVALUE(selected[Year]) || data[Last Yr of Service] = blank()))

     

    return

    sumx(_table,[Column])

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amit

      Unfortunately I got an error message

      "The syntax for 'RETURN' is incorrect. (DAX(FILTER(data,data[First Yr of Service]<=SELECTEDVALUE(selected[Year]) && (data[Last Yr of Service]>SELECTEDVALUE(selected[Year]) || data[Last Yr of Service] = blank()))RETURNSUMX(_Table,[Column])))."

       

      Can you help? Sorry I am not very good in DAX

       

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Anonymous , Try like 

        Measure =
var _Table = FILTER(data,data[First Yr of Service]<=SELECTEDVALUE(selected[Year]) && (data[Last Yr of Service]>SELECTEDVALUE(selected[Year]) || data[Last Yr of Service] = blank()))
return
sumx(_table,[Column])