Keep Min and Max on graph while changing selection

[Anonymous]

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 brands. I would like to keep the min and max on the graph while I change the selected brand.

Any IDEA ?

[amitchandak]

Not sure I got but, All, all except are few option to explore

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),all(brand),DATESMTD(dateadd('Date'[Date],-1,QUARTER)))

In above brand filter will be ignored

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]

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 · Accepted solution]

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]

Thanks Amit. Works great ! 👍

[parry2k]

@Anonymous how does your data looks like? What measure you are using for min and max? Basicall in your measure you need to ignore Band filter which can be achieved by using ALL  function.