topic behavior of measures written in various forms in DAX Commands and Tips

behavior of measures written in various forms

vlsantos — Wed, 03 Apr 2024 19:06:50 GMT

Hello forum, today I come to ask a curiosity when I'm writing some measurements, related to time. This measurement that I will add as an example is used to calculate a field in the month prior to the one selected in the filter (2023-12-01). My question is the following, why out of these 3 options, only one of them returns value?

Re: behavior of measures written in various forms

StrategicSavvy — Wed, 03 Apr 2024 22:27:08 GMT

Hi vlsantos

In case of 1st and 2nd filters get overwritten . In case of 3rd one only the innermost filter get into consideration.

Re: behavior of measures written in various forms

Anonymous — Thu, 04 Apr 2024 03:17:11 GMT

Hi vlsantos

Just as StrategicSavvy said that, in case of 3rd one only the innermost filter get into consideration.

When the Calculate function is used in nesting, the order of action is from the outermost layer to the innermost layer, if the inner filter condition is in the same column as the outer filter condition and conflicts with it, the inner filter overrides the outer filter condition;

You can also use the keepfilters function to change the mechanism of Calculate's filter conditions, instead of directly overriding the original filter context, you can add new conditions based on the original context, resulting in the intersection of multiple conditions.

This link can help you:

CALCULATE'S NESTED USAGE

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.