Filter

SELECTEDVALUE is a DAX function that returns the value when there is only one distinct value in a specified column; otherwise, it returns an alternate result. … Read More

SELECTEDMEASURENAME is a DAX function that returns the name of the measure currently being evaluated. Syntax Return Values A string value holding the name of the … Read More

SELECTEDMEASUREFORMATSTRING is a DAX function that returns the format string for the measure currently being evaluated. Syntax Return Values A string holding the format string of … Read More

SELECTEDMEASURE is a DAX function that returns the measure currently being evaluated. Syntax Return Values A reference to the measure that is currently in context when … Read More

NATURALJOINUSAGE is a DAX function that adds a table as a natural join into the filter context. Syntax Argument Properties Description Expression The table expression to … Read More

SAMPLECARTESIANPOINTSBYCOVER is a DAX function that returns a sample subset by plotting rows as points in 2D space based on input coordinates and radius, then removing … Read More

REMOVEFILTERS is a DAX function that clears filters from specified tables or columns. Syntax Argument Properties Description TableNameOrColumnName Optional The name of an existing table or … Read More

KEEPFILTERS is a DAX function that modifies the filtering behavior of CALCULATE and CALCULATETABLE functions to retain existing filters. Syntax Argument Properties Description Expression CALCULATE or … Read More

LOOKUPVALUE is a DAX function that retrieves a value from a table based on specified search criteria. Syntax Argument Properties Description Result_ColumnName The column that contains … Read More

ISSELECTEDMEASURE is a DAX function that returns TRUE if one of the specified measures is currently being evaluated. Syntax Argument Properties Description Measure Repeatable Measure,… Return … Read More