Forum Discussion
Keep Min and Max on graph while changing selection
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
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
Hi,
Thank you for you answers. Here are the PBIX and the Excel file I have been working on to be more precise.
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 :
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/823601Thanks Amit. Works great ! 👍