Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am tring to creat a matrix that holds groups from the same column with different combination.
SourceTable
Group | Type |
1 | A |
2 | B |
3 | A |
Then add them to a matrix row , the type to the column, and a value that counts.
OutPutMatrix
Group | A | B |
Group 1 | 1 | |
Group 2 | 1 | |
Group 3 | 1 | |
Group 1 & 3 | 2 | 0 |
Solved! Go to Solution.
@CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual
@CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
94 | |
92 | |
84 | |
69 |
User | Count |
---|---|
162 | |
129 | |
126 | |
106 | |
98 |