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])
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])
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Amit,

         

        Unfortunately I am still seeing error message: "Column 'Column' cannot be found or may not be used in this expression." Can you help?