behavior of measures written in various forms

[vlsantos]

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?

[Anonymous · Accepted solution]

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.

[StrategicSavvy]

Hi @vlsantos 

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