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 have 2 tables
Id | zone | Amount |
1 | North | 10 |
2 | South | 15 |
3 | North | 5 |
4 | South | 6 |
5 | North | 4 |
6 | North | 12 |
7 | South | 15 |
8 | North | 3 |
9 | South | 9 |
10 | North | 11 |
11 | South | 15 |
12 | South | 4 |
13 | North | 2 |
14 | South | 12 |
15 | South | 4 |
16 | North | 14 |
17 | South | 10 |
18 | South | 4 |
19 | North | 13 |
20 | South | 3 |
Zone | Goal |
North | 100 |
South | 110 |
And I need to create this Visualization Matrix
South | North | Total | |
Goal | 110 | 100 | 210 |
Amount | 97 | 74 | 171 |
Compliance | 88% | 74% | 81% |
Where Amount is the sum from the amount form the first table for each zone
Goal is just the value from the second table without any operation (I am having trouble doing this part).
The last row is just the % for each zone (Amount.South/Goal.South and the same for the North).
I am having trouble showing just the value in the first row without any operation, maybe I’m not relating the 2 tables in a good way....
Thanks
Solved! Go to Solution.
Please have a look at the workspace on this link
It shows the matrix as you described it on your message
Please have a look at the workspace on this link
It shows the matrix as you described it on your message
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |