Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JimB-GA
Helper III
Helper III

How to create a table with 2 filtered criteria

Good day all,

 

I have a filtered table which is pulling from a table named 'transactions'.

 

Savings = filter(transactions,transactions[Account Name]="Savings")
 
Is it possible to create the table with 2 criteria?  I have another account name = 'Money Market"
 
THanks
 
Jim from GA
1 ACCEPTED SOLUTION
EugenioJunior
Frequent Visitor

Hi @JimB-GA 

Try this:

 

FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")

View solution in original post

4 REPLIES 4
v-chuncz-msft
Community Support
Community Support

@JimB-GA ,

 

You may also use The IN operator in DAX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
EugenioJunior
Frequent Visitor

Hi @JimB-GA 

Try this:

 

FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")

Thanks.  Just learned about the double pipe!

Thanks!

 

 

Jim-GA

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.