topic Re: Calculate AVERAGE from MIN of 2 measures in DAX Commands and Tips

Calculate AVERAGE from MIN of 2 measures

Jpmercier00 — Thu, 09 Sep 2021 14:29:47 GMT

Good morning

Hope you can help me...

I have two measures from several calculations. From these two mesures I get the daily minimum using MIN()

What I would like to achieve is to have at the total column, the average of these minimum values.

What I get is the MIN of the average of the two measures.

Any idea how to tackle this?

For this example, as you can see, I have the minimum value for each day. What I am trying to acheive is to have 17.84 in the total row. average(17.67,17.83,18.02).

Thanks for your support!.

Re: Calculate AVERAGE from MIN of 2 measures

amitchandak — Thu, 09 Sep 2021 17:00:06 GMT

Jpmercier00 , Assume you have min price measure, you use a measure like

averagex(values(Table[YYYY-MM]), [Min Price])

Re: Calculate AVERAGE from MIN of 2 measures

Jpmercier00 — Thu, 09 Sep 2021 17:22:58 GMT

amitchandak So simple, so direct! Thank you very much!

MXN_Final_Price_test = AVERAGEX('CALENDAR',[MXN_Final_Price])

Re: Calculate AVERAGE from MIN of 2 measures

Schmidtmayer — Thu, 09 Sep 2021 17:24:36 GMT

Just recreated your data:

Using the following measure:

gives the correct result: