DAX equivalent of SQL filter not LIKE ('Diteruskan')

[rudiistianto]

There's an extremely similar equivalent for SQL's NOT IN - I have no imagination, so an example extremely similar to the last one I actually wrote:

Select * from report where report_status not in ('Diselesaikan')

NOT IN doesn't work - what's the simpliest DAX equivalent of SQL's NOT IN? 

thanks.

[VahidDM]

Hi @rudiistianto 

Please see this link:

https://community.powerbi.com/t5/Desktop/DAX-equivalent-of-SQL-s-NOT-IN/m-p/586184

https://docs.microsoft.com/en-us/dax/not-function-dax

https://www.sqlbi.com/articles/the-in-operator-in-dax/

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[rudiistianto · Accepted solution]

Thanks for your suggestion.
the last one I actually wrote in pbx :

Measure = CALCULATE( COUNT('patra_inspection entity__report'[report_status]),NOT('patra_inspection entity__report'[report_status]) = "Diselesaikan")