Create a table filtering for multiple values - logical OR

[JimB-GA]

Hello community,

I have a table named "transactions" with a column named "account name".  Within the account name column, there are numerous accounts.  I would like to build a table to filter for two specific accounts.  I can create a table filtering for one account, but cannot figure out how to  filter for account "A" or account "B"

Would greatly appreciate any and all assistance.d

Jim

[Icey · Accepted solution]

Hi @JimB-GA ,

In DAX, you can use "||" as "or". You can refer to this article: Logical operators.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey · Accepted solution]

Hi @JimB-GA ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Icey · Accepted solution]

Hi @JimB-GA ,

In DAX, you can use "||" as "or". You can refer to this article: Logical operators.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JimB-GA]

My apologies!  I have been out of the country.  Works perfectly!

Thanks so much!

Jim

[MantasLukauskas]

Did you try slicer for this task? Because in slicer options you can choose multiple selection and then see filtered values based on two accounts 🙂 

Mantas