Qustion concerning to DAX "AND Syntax"

[Anonymous]

Dear all,

we have a power BI report and we created a role, into the "Table filter DAX expression" we put the following input:

[CustomerNumber_Data] = "C0010"

The filter works perfectly, but we would like to extend the role, example:

[CustomerNumber_data] = "C0010" && "C0005" && "C1234"

We are not able to get it working with trying different syntax.

Could you please help me?

Thank you, Best regards

Marc

[Anonymous]

That did the trick, thank you so much!

[Anonymous]

Hi,

thank you for your help, but now we get the following error:

"A table of multiple values was supplied where a single value was expected"

Best regards

Marc

[amitchandak · Accepted solution]

@Anonymous , Try like

[CustomerNumber_data] in { "C0010", "C0005" ,"C1234"}