Average Calculation in Table Visual

Hi tanmaym93 ,

Is this result you want to achieve?

If it is, you can according to my testing process:

For easy calculation and clear understanding, I create an index column and two measures

1. For index column, you can add it in power query
2. The first measure is to calculate the Cumulative value：

           You can try this measure:

  Cumulative value = var _hc=SELECTEDVALUE('Table'[HC])
  return SUMX(FILTER(ALL('Table'),'Table'[HC]<=_hc),'Table'[HC])

then you can get the Cumulative value:

    3.  The second measure is what you want to calculate—the average of HC

         You can use this measure:

  avg hc = 'Table'[Cumulative value]/SELECTEDVALUE('Table'[Index])

and finally , the result is as the above shows

Best regards,

Community Support Team Selina zhu

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

Hi Selina - This is the result I am looking to achieve, however my HC value is calculated as a Sum of the HC column that I have in my dataset..

My dataset has 18k rows and I have assigned the value "1" for all the rows.

As a result, I am unable to obtain the result through the Cumulative value measure you suggested.

Let me know if you need additional information from me that can assist you.

How to calculate average of 4 rows in PowerBi visual table? Please help me with the forula to create a new Measure