Optiminizing filters in DAX

[ThomasWeppler]

Hi power BI comunity

I want to optimize the filters in my Power BI report to make it fast to code in and make it all run faster for the end user.

Now I can write a filter in DAX like this

Registrationen[internalid] <> 3,

Registrationen[internalid] <> 5,

Registrationen[internalid] <> 13,

and it works fine.

But I think the preformance could be better if I just read throught the date once so I would like to write something like this.
Registrationen[internalid] <> {3,5,13}
But when I write this line of code it doesn't work.

Am I right to think that such a line would be faster?
Is there another way to write it that works in DAX?

[NickolajJessen · Accepted solution]

here's a link to using NOT IN in Power BI Dax.
https://community.powerbi.com/t5/Desktop/DAX-equivalent-of-SQL-s-NOT-IN/m-p/586192#M277794

You can use Power Bi's built in Performance Analyzer to test various measure speed.

Does this solve your problem?