cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Torudd-55
Frequent Visitor

Matrix

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

112
 13
 14
213
 3
33
 13
 14
 15
414
 15
513
 3
612
 13
713
 14
 3

 

And the result of the measure i would like to get from this table is as below, the bold numbers:

 

item.no

     
312131415
300421
1200210
1342031
1421302
1510120

 

Thanks in advance!

 

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @Torudd-55 ,

 

You could pivot item.no column in the query editor.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
v-eachen-msft
Community Support
Community Support

Hi @Torudd-55 ,

 

You could pivot item.no column in the query editor.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

amitchandak
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors