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")

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."