Filter Power BI Dax based on condition

[HugoTran]

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 not be determined. This can happen when a measure formula rfers to column that contain many values without specifying aggreation..." I am new with this and any help are greatly appreciated. Thank you in advance!

[Dangar332]

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

[HugoTran]

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 · Accepted solution]

Hi, @HugoTran 

filtercondition =

If( min(tablename[status])="new" || min(tablename[sme group assigned])<>blank(),"filter","not filter")

[bchager6]

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

[HugoTran]

@bchager6 Definitely appreciated for your help. Thank you! 

[Dangar332]

Hi, @bchager6 

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

[HugoTran]

Got it. Thanks a bunch.

[HugoTran]

correction - MIN function*

[bchager6]

@HugoTran  You'll need to use an aggregation function in those cases (like MAX), or you can try using the FIRSTNONBLANK function with your example.

[HugoTran]

Thank you for the quick reply. when I added the MAX aggr function, I get the following error.

[bchager6]

@HugoTran  I edited my initial response. Try FIRSTNONBLANK with your example.

[HugoTran]

Tried FIRSTNONBLANK and get another error "Too many arguemtns were passed to the FIRSTNONBLANK funciton. The maximum argument count for the function is 2."