In Dax Guide

Summary

The IN operator returns TRUE if a row of values exists or contained in a table, otherwise returns FALSE. ALL: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. EXACT: Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. SUMMARIZE: Creates a summary of the input table grouped by the specified columns. CALCULATE: Evaluates an expression in a context modified by filters. The logical and operator && returns TRUE if both arguments are TRUE, and returns FALSE if any of the arguments is FALSE. The DEFINE MEASURE statement introduces a measure definition in a query (also known as query measure). SUBSTITUTEWITHINDEX: Returns a table which represents the semijoin of two tables supplied and for which the common set of ... SEARCH: Returns the starting position of one text string within another text string. SEARCH is not case-sensitive, but it is ... We are proud to announce great news for GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... ISINSCOPE: Returns true when the specified column is the level in a hierarchy of levels. VALUE: Converts a text string that represents a number to a number.