Forum Discussion
Khramana
3 years agoFrequent Visitor
Need help with Measure condition
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" ...
BA_Pete
3 years agoSuper User
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
3 years agoFrequent Visitor
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_Pete3 years agoSuper User
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