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
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Try this DAX formula:

//calculated column
Projectscore = 
VAR x=
DIVIDE(
    [PointA],
    [PointB]
)
RETURN
IF(
    HASONEFILTER([Projekt]),
    x,
    AVERAGEX(Sheet7, x)/2
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.