Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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
User | Count |
---|---|
51 | |
34 | |
19 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |