What's more efficient: Nesting filters or using a single filter with AND functions?

[MCMcMax]

Hello PBI Community - hope you're having a good day.

I've got a query about what's the most efficient way to filter data in a calculated column using DAX where I've got more than 1 factor that I'm filtering against.

I've got 2 options that work (the "SC" and "O" are VARs) :

1. FILTER(FILTER(FILTER(Tenants,Tenants[S_CliN]=SC),Tenants[Gap_Check]="GAP"),Tenants[SC_Order]<O)
2. FILTER(Tenants,AND(AND(Tenants,Tenants[S_CliN]=SC,Tenants[Gap_Check]="GAP"),Tenants[SC_Order]<O)

Is it a case that the first one makes it quicker because it's steadily reducing down the size of the data being filtered as each filter is applied?

[ERD]

@MCMcMax, I'd say "as usual, it depends"... In terms of these 2 options that might depend on the size of your table (is it large or not) and on the conditions selectivity comparison.

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

[amitchandak]

@MCMcMax , filter returns a table. Nesting means every time you return a table .

So as my me better to return &&.

But you check that using performance analyzer or DAX studio

https://www.sqlbi.com/articles/importing-performance-analyzer-data-in-dax-studio/