Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
vlsantos
New Member

behavior of measures written in various forms

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?

vlsantos_0-1712171073378.png

vlsantos_1-1712171130929.pngvlsantos_2-1712171196841.png

 

 

1 ACCEPTED SOLUTION
v-zhengdxu-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-zhengdxu-msft
Community Support
Community Support

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
Resolver II
Resolver II

Hi @vlsantos 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors