Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Keep Min and Max on graph while changing selection

Hi,   I have a form with multiples questions and notes from 0 to 10 for each questions. I made a graph with the min and max for each questions :   The interviews have been made for several...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    Min_Brand = CALCULATE(MINX(results,results[Moyenne]),ALL(results[Brand]))

     

    Please note as you have other measures in graph, which will still filter and keep on moving question position. You might see min moving. The best way to test is only to have this measure on the graph.

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thank you for you answers. Here are the PBIX and the Excel file I have been working on to be more precise.

Test_Brand.pbix 

Test_Brand.xlsx 

As you can see, when I select a brand, the min and max disappear.

I have tried the ALL function but it does not seem to work with MINX :

Min_Brand = CALCULATE(MINX(results;results[Moyenne];ALL(results[Brand])))
 

 

amitchandak's avatar
amitchandak
Super User
6 years ago

Try

Min_Brand = CALCULATE(MINX(results,results[Moyenne]),ALL(results[Brand]))

 

Please note as you have other measures in graph, which will still filter and keep on moving question position. You might see min moving. The best way to test is only to have this measure on the graph.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Amit. Works great ! 👍