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

Thanks for the help. When I update the agg function to MIN, I got error "Too many arguemtns were passed to the FIRSTNONBLANK funciton. The maximum argument count for the function is 2."

Dangar332's avatar
Dangar332
Resident Rockstar
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

    Got it. Thanks a bunch.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Dangar332  I'm pretty sure you saw that I was already helping here, and stepped on my work none the less.

    • Dangar332's avatar
      Dangar332
      Resident Rockstar
      2 years ago

      Hi, Anonymous 

       

      Listen brother I am just helping HugoTran it's not a competition.

    • HugoTran's avatar
      HugoTran
      Frequent Visitor
      2 years ago

      Anonymous Definitely appreciated for your help. Thank you!