Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
3 years ago
Solved

Sum & average

 Hi Guys,   Need your support please,   I have the following dataset   for each of the day: I want to Sum people based on city, then i want to average the city based on flag.  so Ger = average...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Download the PBI file.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

This measure works

Measure = AVERAGEX(VALUES(Data[Flag]),[Total])

Hope this helps.

  • abukapsoun's avatar
    abukapsoun
    Post Patron
    3 years ago

    Hi Ashish_Mathur 

     

    What is the "Total" measure you have created? I can see it in your screenshot but not in the formula

     

    Thank you

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Download the PBI file.