Value Dax Guide

Summary

DISTINCT: Returns distinct (unique) The IN operator returns TRUE if a row of FIND: Returns the starting position of one text string within another text string. FIND is case-sensitive and accent-sensitive. HASONEVALUE: Returns true when there's only one EXACT: Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. GEOMEAN: Returns geometric mean of given column reference. UNION: Returns the union of the tables whose columns match. CLOSINGBALANCEMONTH: Evaluates the specified expression for the date corresponding to the end of the current month. DETAILROWS: Returns the table data corresponding to the DetailRows expression defined on the specified Measure. SUMMARIZE: Creates a summary of the input table grouped by the specified columns. SQRT: Returns the square root of a number. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL.