Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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%
Solved! Go to Solution.
I will reply myself, as i found the solution.
Maybe it can help another person
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
I will reply myself, as i found the solution.
Maybe it can help another person