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
Anonymous's avatar
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