Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have a question and appreciate if someone provide me with the solution.
My data is 2 tables: Speed Table and Productivity Table.
Speed Table:
City | Column1 | Column2 | Column3 |
A | 1 | 6 | 1 |
B | 4 | 9 | 4 |
C | 0 | 9 | 3 |
D | 1 | 5 | 9 |
A | 8 | 7 | 0 |
B | 9 | 1 | 6 |
C | 0 | 7 | 4 |
D | 1 | 8 | 3 |
Productivity Table:
City | Fac1 | Fac2 |
A | 1 | 6 |
B | 4 | 9 |
C | 0 | 9 |
D | 1 | 5 |
A | 8 | 7 |
B | 9 | 1 |
C | 0 | 7 |
D | 1 | 8 |
And I want to create this matrix from these tables
by grouping by the data of speed table and productivity tables and pivoting them and appending these two table I can create the below matrix:
My main challenge is the Fac1/Fac2. I dont know how to add this measure in the maxtrix. I appreciate it if some one can help me. Fac1/Fac2 means divide( Fac1,Fac2).
the values in matrix is the calculate (sum( column1)), calculate (sum( column2)),calculate (sum( column3)),calculate (sum( fac1)),calculate (sum( fac2)), divide( Fac1,Fac2)
I want to add this measure in the row . this is the my problem not the calculation
Little confused. You said it is a matrix right? What did you place in the rows, columnd values?
You did not explain how did you get to this matrix at the first place.
I revised the post .
by grouping by the data of speed table and productivity tables and pivoting them and appending these two table I can create the below matrix:
My main challenge is the Fac1/Fac2. I dont know how to add this measure in the maxtrix. I appreciate it if some one can help me. Fac1/Fac2 means divide( Fac1,Fac2).
the values in matrix is the calculate (sum( column1)), calculate (sum( column2)),calculate (sum( column3)),calculate (sum( fac1)),calculate (sum( fac2)), divide( Fac1,Fac2)
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 | |
26 | |
20 | |
15 | |
11 |
User | Count |
---|---|
77 | |
62 | |
44 | |
18 | |
12 |