Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The average from average

Hi Folks, i am a Newcomer in Power BI and i have a question: my table does look like:   Projekt, Projectscore, PointA, PointB A,              66, 67 %, 80, 120 B               31,25 %,  50, 160 ...
Need Help
SivaMani's avatar
SivaMani
Resident Rockstar
6 years ago

Anonymous,

 

Here you go,

 

Create a measure like below,

Projectscore = DIVIDE(SUM(PointA),SUM(PointB))

Projectscore Derived = AVERAGEX(<Table Name>, Projectscore)

Use Projectscore Derived in the table.

 

Appreciate your kudos!

 

Regards,

Siva Mani

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi SivaMani,

    first of all thanks a lot for your time and responce,

    my real example does look like:

    Project, Aver, PointA, PointB

    a, 67,22%,  363, 540

    b, 53,61%,  193, 360

    c, 69,64%, 195, 280

    d, 69,00%, 31, 50

    e, 37,22%, 67, 180

    f, 61,14%, 107, 175

    Total:  60,32%  956, 1585

     

    but instead of 58,47% my total avergae is: 60,32%, how can i calculate my averages to have the value 58,47 %

    i hope, i explained well, if not, please let me know

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      6 years ago

      Hi Beck11,

       

      Have you tried my solution for this case?

       

      Are you still facing this issue?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi SivaMani,

        thanks a lot for your responce, unfortunatelly i am still facing my issue.