New article in the From SQL to DAX series: IN and EXISTS functions in #DAX

I published another article in the “From SQL to DAX” series I launched many months ago on This time, the goal is to analyze DAX alternatives for IN and EXISTS operators that you have in SQL. The name of the article is From SQL to DAX: IN and EXISTS.

I hope that a syntax corresponding to the SQL operator IN will be available in future versions of DAX, it would simplify the syntax to write for long list of values to include in a selection.

Article written by
Post originally appeared on:

 Enclose code in comments with <PRE></PRE> to preserve indentation.