MINX return different result

[NickProp28]

Dear Community,

This is my 3 month sales data. 

And I would like to create another card to show the lowest value. Which is month March with value '2400'. 

I have apply MINX function, 

$ Min Month Sales = MINX( ALLSELECTED( 'Calendar' ), [$ Sales] )

But its not return the expected value. 

Appreciate any help provided! 

Here is the pbix: https://drive.google.com/file/d/1QikkvU7dhNQ2jgnMsEstTzLwpJzRI17a/view?usp=sharing

Thank you! 

[ALLUREAN]

Hi @NickProp28 

Can you try this? It will take the min value and will keep it also when you select month from the slicer. 

$ Min Month Sales = CALCULATE(MINX(VALUES('Calendar'[Month]),[$ Sales]),ALL('Calendar'))

https://www.dropbox.com/s/yuqq95ggx9c5ims/MINX%20issues%20%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

[Kumail]

Hello @NickProp28 

You could try $ Min Month Sales =

MINX( ALLSELECTED( 'Calendar'[Month] ), [$ Sales] )

This will give you the correct min monthly value.

Regards

Kumail Raza

[Jihwan_Kim]

Hi,

If your expected result is 2400, please try the below measure.

$ Min Month Sales =

MINX( ALLSELECTED( 'Calendar'[Month] ), [$ Sales] )

[amitchandak · Accepted solution]

@NickProp28 , Based on what I got, Try like

$ Min Month Sales = MINX( values( 'Calendar'[Month] ), [$ Sales] )

, assuming $sales is a measure else use

calculate(sum(Table[$ Sales] ))