Forum Discussion
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...
hi, HugoTran
when you use measure you need aggegation functions like sum(), min(), max(),....
try like below
filtercondition =
min(tablename[status])="new" || min(tablename[sme group assigned])<>blank(),"filter","not filter")
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."
correction - MIN function*
Hi, HugoTran
filtercondition =
If( min(tablename[status])="new" || min(tablename[sme group assigned])<>blank(),"filter","not filter")
