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