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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating a new table out of existing table with filters

Hey guys,

I've got a table called 'Data' and I need to create a new table out of this one, only with the following filters:

LaZZaNoVa61_0-1651599204495.png


The column fonds needs to be "Alliance"
The column interaction_type needs to be "OPEN"

How can I do this using DAX?

With kind regards,

Lazzanova

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Anonymous :

TABLE2 = 
FILTER (
    TABLE1,
    TABLE1[fonds] = "Alliance" && TABLE1[interaction_type] = "OPEN"
)


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@Anonymous :

TABLE2 = 
FILTER (
    TABLE1,
    TABLE1[fonds] = "Alliance" && TABLE1[interaction_type] = "OPEN"
)


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.