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

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

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
    Icon for Resident Rockstar rankResident 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!