Need help with Measure condition

[Khramana]

Hello Power BI lovers!

I'm still in process of Power BI expressions acqusition and need some advice how to make a proper expression.

I have table: "Device statistics"

In "Device statistics" I have these columns:

Device Name	RAM in Freeze	City
AN12345GI	520	Berlin
KR5562KOT	800	Paris
LO894H78D	500	Berlin
PI4H49JTH7	727	Ankara
HI5O89FHE	768	Minsk
KK456HTJW	520	Zagreb

I need to show the average RAM in freeze by cities like (sum of RAM of the devices by location)/(quantity of the devices in this location).
To see: Berlin - 510, Paris - 800, Zagreb - 520, etc

If I chose Pie chart, put "RAM in Freeze" in Values, chose "Average" "City", put "City" in Details, it calculates average from the whole sum like 520+800+500+727+768+520.

Could you please advise how I can figure it out correctly?


Thanks in advance!

[BA_Pete]

Hi @Khramana ,

You should just be able to create a measure like this and use it in the Values section of your pie chart:

_averageRamInFreeze = AVERAGE(yourTable[RAM in Freeze])

Pete

[Khramana]

I guess I figured it out using your measure as an example just replacing Average with Median and changing widget to card for better vizualization.

Thank you very muh! 🙂

[BA_Pete]

I'm not sure what your expected output was, but the AVERAGE measure works fine for me:

To get averages just over City, you must only have [City] and the measure in the visual (or filter context).

Pete

[Khramana]

Hello @BA_Pete 

Thank you for the reply!
But in this case it shows average in total taking all the cities. But not average for Berlin, Paris, etc...

This day I understood that the most exact way to understand the RAM will be to get Median by the cities or Percentile, seems that it make the question a bit more complicated too... Thinking about to make one more post with a question how to get Fashion for this case..