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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Measure that recalculates when a filter is applied

Hello everyone,

 

I have a measure that calculates de "Stands/hr" for all the trips that are shown in the bar chart. When I filter the trips to remove the outliers, the "Stands/hr" measure does not recalculate to adjust to these new amount of trips.

 

I would like this measure to adjust the calculation depending on the filter it has at any given time.

 

Thanks!

 

1.jpg2.jpg

4 REPLIES 4
D4imi0n
Helper I
Helper I

Hi Luis,

so I don't know if this is a solution for you but maybe this works as a hint

D4imi0n_0-1616079127631.png

D4imi0n_1-1616079171173.pngD4imi0n_2-1616079252963.png

 

I created a Calculated table. I think there is a better solution but with this table I was able to set a "Filter on this page". Problem is that you have a new table. 

As I said, only a possible clue to get further.

 

Cheers Jeffrey

 

D4imi0n
Helper I
Helper I

Hi LuisGerardoSR,

 

is it possible to use the measure "Stands/hr" also in the "Filters on this page"?

Maybe you could filter the hrs there.

 

Cheers Jeffrey

Anonymous
Not applicable

it is not allowing me to place this measure in the "filters on this page".

Hi sry,

I have read over the fact that you use a measure.

I just rebuilt your example and am looking at it now.

 

Cheers, 

Jeffrey

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors