Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jpmercier00
Frequent Visitor

Calculate AVERAGE from MIN of 2 measures

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?

 

Jpmercier00_1-1631197586103.png

 

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!.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

 

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

View solution in original post

3 REPLIES 3
Schmidtmayer
Helper I
Helper I

Just recreated your data:

Schmidtmayer_0-1631208097077.png

Using the following measure:

Schmidtmayer_1-1631208181612.png

gives the correct result:

Schmidtmayer_2-1631208223923.png

 



amitchandak
Super User
Super User

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

 

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

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

 
MXN_Final_Price_test = AVERAGEX('CALENDAR',[MXN_Final_Price])
 
 Jpmercier00_1-1631208128587.png

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors