topic Re: Filter does not apply properly in DAX Commands and Tips

Filter does not apply properly

knut12212 — Mon, 15 Sep 2025 10:27:17 GMT

I have an issue with this function. The function takes the maximum value from the column FC-Werte. The problem is that when I apply a filter, this maximum value does not change. In other words, the filters are not working reliably here. Why is that?

That's the measure I am referring to:

Linie FC =

VAR AktuellerMonat =

SELECTEDVALUE( 'PBI - Nettoaufwand'[Monate (in Zahlen)] )

VAR MaxFCGefiltert =

MAX ( 'PBI - Nettoaufwand FC'[FC Werte] )

RETURN

DIVIDE ( MaxFCGefiltert, 12, 0 ) * AktuellerMonat

Re: Filter does not apply properly

rohit1991 — Mon, 15 Sep 2025 13:30:41 GMT

Hi knut12212

I’ve updated my answer below with your reply.

The reason your MAX doesn’t react to filters is because you used it directly:

VAR MaxFCGefiltert = MAX ( 'PBI - Nettoaufwand FC'[FC Werte] )

This always scans the entire column. That’s why it doesn’t change.

Fix: wrap it with CALCULATE so it respects filter context:

Could you please try this: MaxCoefficient = VAR SelChannel = SELECTEDVALUE ( 'PB - Nettoaufwand FC'[Sales Channel] ) RETURN CALCULATE ( MAX ( 'PB - Nettoaufwand FC'[C Werte] ), 'PB - Nettoaufwand FC'[Sales Channel] = SelChannel )

Example:

Without CALCULATE >> Max = 400 (global).
With CALCULATE + Filter (Monat=2) >> Max = 300 (filtered).

Re: Filter does not apply properly

knut12212 — Mon, 15 Sep 2025 13:12:41 GMT

Unfortunately, it does not work. I will share my table. Maybe, this way it will be easier to solve my problem.

Filter (Sales Channel -> FOA94), then 300 is the right answer. However, my current measure takes the maximum value from the column FC-Werte 640.

Re: Filter does not apply properly

FBergamaschi — Mon, 15 Sep 2025 13:13:37 GMT

Hello knut12212

I would need to check your pbix to understand what you write because it sounds weird. MAX will anyway consider only what the filter context allows to see.

Can you please share the pbix? Also via private message if you prefer.

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: Filter does not apply properly

Selva-Salimi — Mon, 15 Sep 2025 15:48:57 GMT

Hi knut12212

you just need to use calculate( max(....))

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: Filter does not apply properly

v-achippa — Fri, 19 Sep 2025 14:37:39 GMT

Hi knut12212,

Thank you for reaching out to Microsoft Fabric Community.

Thank you rohit1991, Selva-Salimi and FBergamaschi for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa