Divide each item of a group by the total av

[Anonymous]

Hi, good day

I am new in power Bi, and I am trying to do this

I am analyzing the volume of some stocks. I have many sectors, and every sector there are many stocks

I want to calculate the total average volume of per sector, and then, divide each volume of each stock by the total average of the sector, like this

Filter Sector: Finance

Sector Finance.......Volume..........total average.......Volume ratio

AAA...............................800.....................1782.........................45%

BBB...............................646.....................1782.........................36%

CCC...............................3900..................1782.........................219%

[Anonymous]

Sorry, I cut the message,

So, the problem is that what I am getting as shown below, is the total average of each stock, not the total average of the group

Could someone give me a hand

Thanks very much

[Anonymous · Accepted solution]

I will reply myself, as i found the solution.

Maybe it can help another person