Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help with the average calculated measure

Hi all,   I have data in PowerBI with three columns as shown below in column A, B and C. I am trying to get the average value by objective as expected in column D. I've tried using this formula: ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous try following measure

     

    Avg Object = CALCULATE( AVERAGE( Query1[Amount] ), ALLEXCEPT( Query1, Query1[Object] )  )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous try following measure

 

Avg Object = CALCULATE( AVERAGE( Query1[Amount] ), ALLEXCEPT( Query1, Query1[Object] )  )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  Thank you so much for your help !!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k By the way, I also would like the calculated measure to be dynamically changed according to the month filter for each objective. For example, if I filter Jan19 until May 19 then the calculated measure should be the average of the value of the five months, not the average value of six months as of now. How could I achieve this?