Creating a new table out of existing table with filters

[Anonymous]

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:

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

[SpartaBI · Accepted solution]

@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 🙂