Filter Functions

The SELECTEDVALUE function in DAX retrieves the value of a column when the context has exactly one value for that column. If the column contains multiple values or no values,…

The ALLEXCEPT function in DAX clears all filters from a table except for the filters applied to the specified columns. It is a versatile tool for managing filter context dynamically,…

The FILTER function in DAX is one of the most versatile and powerful functions for modifying the filter context in Power BI, Excel, and other DAX-enabled tools. It allows you…

The ALL function in DAX is one of the most important and powerful functions used to remove filters from a table or column in your data model. It allows you…

The LASTNONBLANK function in DAX is used to return the last non-blank value in a column or expression based on the current filter context. It is a valuable tool for…

The CALCULATE function in DAX is one of the most powerful and fundamental tools for modifying the filter context in Power BI, Excel, and other DAX-based platforms. It allows users…

The FIRSTNONBLANK function in DAX is used to return the first non-blank value in a column or expression based on the current filter context. It is particularly useful for identifying…

The ALLSELECTED function in DAX returns all rows in a table or column while retaining filters applied by slicers or visuals in the current report. Unlike ALL, it respects outer…

The LOOKUPVALUE function in DAX (Data Analysis Expressions) retrieves the value from a column based on specified criteria. It is widely used for row-level lookups and enables dynamic relationships between…

The REMOVEFILTERS function in DAX clears filters from specific columns or tables in the filter context. This is useful for calculations that need to ignore certain filters applied by slicers,…