Forum Discussion

HugoTran's avatar
HugoTran
Frequent Visitor
2 years ago
Solved

Filter Power BI Dax based on condition

Hi All -    I am trying to filter a table base on the following condition (Status=New, SME group is not populated (blank)) but it came back with error " A single value for column [] in table [] can...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, HugoTran 

     

    filtercondition =

    If( min(tablename[status])="new" || min(tablename[sme group assigned])<>blank(),"filter","not filter")

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HugoTran  You'll need to use an aggregation function in those cases (like MAX), or you can try using the FIRSTNONBLANK function with your example.

 
HugoTran's avatar
HugoTran
Frequent Visitor
2 years ago

Thank you for the quick reply. when I added the MAX aggr function, I get the following error.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HugoTran  I edited my initial response. Try FIRSTNONBLANK with your example.

    • HugoTran's avatar
      HugoTran
      Frequent Visitor
      2 years ago

      Tried FIRSTNONBLANK and get another error "Too many arguemtns were passed to the FIRSTNONBLANK funciton. The maximum argument count for the function is 2."