USERELATIONSHIP vs TREATAS
Example: They want to use a different relationship than the one that already exists. A table can only have one (active) relationship with another table. Sometimes a situation arises where another relationship is also needed. The other relationship will then be set to inactive. The expression USERELATIONSHIP aims to make an inactive relationship active within […]
FILTER vs KEEPFILTERS
Example: Only customer A needs to be visible. To be able to see only customer A, you can use the expression FILTER or KEEPFILTERS. Both expressions have the purpose of filtering data, but they work in a different way. The FILTER expression is a table filter expression. It returns a table object in the background […]
ALL vs RemoveFilters
Example: They want to see the total for all customers. The purpose of the ALL expression is to ignore any filter that has been applied. The ALL expression can be used as a table filter expression. In doing so, it creates a table of data in the background without filters applied. In addition, ALL can […]
Calculate
The CALCULATE expression is perhaps the most important expression in the DAX library. The CALCULATE expression can be used to modify existing filter context or to add new filter context. In the example below, the base expression SUM was initially used. The expression SUM takes one column and calculates the total. Filter context is not […]