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