Forum Discussion
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 ...
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
If the pointB is a measure, you can change the measure to
Measure = AVERAGEX('Table',DIVIDE(CALCULATE(SUM('Table'[PointA])),CALCULATE([POINTB]),0))
It shows the correct result in my example, if you can't get the 58.47%, you may need to give more details of your data.
Aiolos Zhao