Forum Discussion

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

Anonymous

Not applicable

6 years ago

Hi Anonymous ,

I think SivaMani 's method is the solution, and if you only want one measure to solve that, you can use the below measure, that works on my desktop.

Measure = AVERAGEX('Table',DIVIDE(CALCULATE(SUM('Table'[PointA])),CALCULATE(SUM('Table'[PointB])),0))

Please try.

Aiolos Zhao

Anonymous
Not applicable
6 years ago
Hi Zhao,
thanks a lot for your responce, my issue 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
- Anonymous
  Not applicable
  6 years ago
  Hi Anonymous ,
  
  I'm not sure whether you are using my meausre, that's what you want, I try it in my desktop.
  
  Measure = AVERAGEX('Table',DIVIDE(CALCULATE(SUM('Table'[PointA])),CALCULATE(SUM('Table'[PointB])),0))
  
  Aiolos Zhao
  - Anonymous
    Not applicable
    6 years ago
    Aiolos thanks a lot for your responce and help, but i am still facing my issue:
    i give some more details.
    the Field: PointB is a calculated Field:
    PointB = CALCULATE(COUNT(Sheet1[Nr])) * 5
    
    and if i use your expression:
    Measure = AVERAGEX('Table',DIVIDE(CALCULATE(SUM('Table'[PointA])),CALCULATE(SUM('Table'[PointB])),0))
    
    so i have still the wrong result, how can i implemente the calculated part of my expression in your expression, to have 58,47 %
    
    Do you have any idea?
    Thanks a lot