Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I need to sum grouping data. For example:
- I have two months
- 1st we have 9 000 sales and 10 000 target
- 2nd we have 3 000 sales and 6 000 target
wehn I count progression for months it is:
- 1st - 9 000/10 000 = 90%
- 2nd - 3 000/5 000 = 60%
When I look at year I have (9 000+3 000)/(10 000+ 5 000)= 80%, but for the contest i need to left monthly values (90% and 60%) but when I look on year i need to sum this score (0,9+0,6=1,5)
I know that i can use calculate for every single month and then just recived resoults - but it is too many measures to do it. I think about way to do it easier.
Anyone can halp me? I am very begginer in Power BI.
Solved! Go to Solution.
Hi @Lokisame,
Please try this measure:
percent = SUMX ( VALUES ( TB1[Month] ), CALCULATE ( SUM ( TB1[Sales] ) ) / CALCULATE ( SUM ( TB1[traget] ) ) )
Best regards,
Yuliana Gu
Hi @Lokisame,
Please try this measure:
percent = SUMX ( VALUES ( TB1[Month] ), CALCULATE ( SUM ( TB1[Sales] ) ) / CALCULATE ( SUM ( TB1[traget] ) ) )
Best regards,
Yuliana Gu
Thank you very much 🙂 It is very simple and useful.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |