Select Page

VIDEO: FILTER and ALL Inside CALCULATE Function

by | Jul 28, 2020 | Video

There are many different ways to use the CALCULATE function in DAX. Depending on a task at hand, you might want to put other DAX functions inside CALCULATE, creating nested functions.

Two common functions that you put inside CALCULATE are the ALL and FILTER functions. Watch our simple examples in a video to understand how ALL and FILTER can be used in real-life situations.

 

The ALL function returns all the rows in a table or all the values in columns, ignoring any applied filters.

The FILTER is a table function, which returns a table of values. Often, the function is used as a filter parameter inside the CALCULATE function.

Tags:

DAX | Power BI | video
Share This