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'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's avatar
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
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

    Has your problem been solved? 

    If yes, please consider Accept it as the solution to help the other members find it more quickly.

    If not, Please give us a complete example data model and tell us which columns are  from DAX.

     

    Best Regards,
    Lionel Chen