Get the MIN or MAX from Measures

[JustDavid]

Hello,

I'm new to Power BI and am trying to get the MAX and/or MIN value from the Measures that I create.

As seen from the print screen, I'm trying to get the MIN or MAX from each row of product type from measure [Avg. Amount].

My desired result is the red box in the screen that I need to be in measures as well.

I have attach a very small sample size of the power bi file, but note that the MIN and MAX in the file is not working as to what I desire in the screenshot below

https://www.dropbox.com/scl/fi/28m50ju0392fjxdzfl6vf/MIN-and-MAX-from-Measures.pbix?rlkey=41vpj3k118... 

[JustDavid]

@AnkitaaMishra and @Ashish_Mathur 

I have update my post with updated screenshot with my desired result and attach a small sample size pbix file.

Thanks for your help in advanced

[Ashish_Mathur · Accepted solution]

Hi,

Try these measures

MIN = if(ISBLANK([Avg. Amount]),BLANK(),MINX(GENERATE(ALLSELECTED(tblDate[Fiscal Year],tblDate[Fiscal Quarter]),ALLSELECTED(tblData[MPC],tblData[Product Type])),[Avg. Amount]))

MAX = if(ISBLANK([Avg. Amount]),BLANK(),MAXX(GENERATE(ALLSELECTED(tblDate[Fiscal Year],tblDate[Fiscal Quarter]),ALLSELECTED(tblData[MPC],tblData[Product Type])),[Avg. Amount]))

Hope this helps.

[JustDavid]

@Ashish_Mathur Thank you for your help.

Quick question, on the 2nd half of the ALLSELECTED() that looks at tblData[MPC] and tblData[Product Type].

If I were to remove this filter criteria from the measure, will it work with the Filter Pane (Filter Pane is where it's the same pane with 'Visualization" and 'Data" and/or slicer?

ALLSELECTED(tblData[MPC],tblData[Product Type])

[Ashish_Mathur]

You are welcome.  It should.

[AnkitaaMishra]

Hi @JustDavid , Could you please elaborate what about your problem statement or share some sample output what you are referring to.

[Ashish_Mathur]

Hi,

I cannot understand your question.  Share some data to work with, explain the question and show the expected result.