Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I trying to figure out on how to solve this problem, if it's even possible.
I have a table Date - with years, another table Category (a,b,c) and facts table with value.
Year | A(PC) | B(PC) | C(PC) |
2000 | 8 | 9 | 88 |
2001 | 5 | 15 | 55 |
2002 | 23 | 45 | 11 |
2003 | 69 | 35 | 22 |
2004 | 14 | 22 | 33 |
2005 | 8 | 22 | 5 |
I want to make a matrix with new calculated fields and the add percentage of row total to it. Firstly I've created a measure where I sum up values from the category A with Category B - that gives me the column A+B(PC).
And then create another measure to get the percentage of row total.
The problem is I'm not sure on how to get the calculated filed A+B(PC) into the matrix as a seperate column and include it in the sum of row total.
Year | A(PC) | A(%) | B(PC) | B(%) | A+B(PC) | A+B(%) | C(PC) | C(%) | Total | Total % |
2000 | 8 | 6,6 | 9 | 7,4 | 17 | 13,9 | 88 | 72,1 | 122 | 100 |
2001 | 5 | 5,3 | 15 | 15,8 | 20 | 21,1 | 55 | 57,9 | 95 | 100 |
2002 | 23 | 15,6 | 45 | 30,6 | 68 | 46,3 | 11 | 7,5 | 147 | 100 |
2003 | 69 | 30,0 | 35 | 15,2 | 104 | 45,2 | 22 | 9,6 | 230 | 100 |
2004 | 14 | 13,3 | 22 | 21,0 | 36 | 34,3 | 33 | 31,4 | 105 | 100 |
2005 | 8 | 12,3 | 22 | 33,8 | 30 | 46,2 | 5 | 7,7 | 65 | 100 |
Thank you for all the advice!!
Hi @ngut47 ,
Not being clear about the logic of your calculation, I created the following measures as I understand and added them to the Values pane of the matrix.
Total = SUM(Category[A(PC)]) + SUM(Category[B(PC)]) + SUM(Category[C(PC)])
Total(%) = [A+B(%)] + [C(%)]
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
63 | |
44 | |
17 | |
12 |