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

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?

     

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

      Anonymous , This you have use a column from your table

      sumx(_table,[Column]) as I am not aware of name, I suggested that

       

      like  this can be

      countx(_table,[employee_id])

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks a lot Amit!!! 

        I noticed the "measure" method can only return a number. If I would like to create a chart to show count of male of female employees who were employed using the same filter 

         

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

         

        How do I create a table for that?