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.
Hi everyone reading this post!
I need help with creating a matrix with a calculated value in each cell.
What i want to achieve is to recognize the number of sales a kombination of two different items have together.
As an example, the table could be looking as below:
Orderno item.no
1 | 12 |
13 | |
14 | |
2 | 13 |
3 | |
3 | 3 |
13 | |
14 | |
15 | |
4 | 14 |
15 | |
5 | 13 |
3 | |
6 | 12 |
13 | |
7 | 13 |
14 | |
3 |
And the result of the measure i would like to get from this table is as below, the bold numbers:
item.no
3 | 12 | 13 | 14 | 15 | |
3 | 0 | 0 | 4 | 2 | 1 |
12 | 0 | 0 | 2 | 1 | 0 |
13 | 4 | 2 | 0 | 3 | 1 |
14 | 2 | 1 | 3 | 0 | 2 |
15 | 1 | 0 | 1 | 2 | 0 |
Thanks in advance!
Solved! Go to Solution.
Hi @Torudd-55 ,
You could pivot item.no column in the query editor.
Hi @Torudd-55 ,
You could pivot item.no column in the query editor.
If the order number and item number are there in all rows. Count item_no, in the matrix, should give you the same.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |