Forum Discussion

knut12212's avatar
knut12212
Icon for Helper I rankHelper I
11 months ago
Solved

Filter does not apply properly

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 f...
  • FBergamaschi's avatar
    FBergamaschi
    11 months ago

    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

knut12212's avatar
knut12212
Icon for Helper I rankHelper I
11 months ago

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.

 

  • Selva-Salimi's avatar
    Selva-Salimi
    Icon for Solution Sage rankSolution Sage
    11 months ago

    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.