Forum Discussion

Khramana's avatar
Khramana
Frequent Visitor
3 years ago

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" ...
Need Help
BA_Pete's avatar
BA_Pete
Super User
3 years ago

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's avatar
    Khramana
    Frequent Visitor
    3 years ago

    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's avatar
      BA_Pete
      Super User
      3 years ago

       

      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's avatar
    Khramana
    Frequent Visitor
    3 years ago

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