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 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. SELECTEDMEASURE: Returns the measure that is currently being evaluated. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. ADDMISSINGITEMS: Add the rows with empty measure EXPON.DIST: Returns the exponential distribution. ISINSCOPE: Returns true when the specified column is the level in a hierarchy of levels. The logical and operator && returns TRUE if both arguments are TRUE, and returns FALSE if any of the arguments is FALSE.