Matrix, grouping column and rows

Hi TITO22 
You should create a relationship  between 2 tables (item id is a key)

create a measure for the sum of sales :

sum_sales = sum('Sales table'[Sales])+0 

**+0 is to have zeros and not blanks

Create the matrix 
Store - employees on rows

Category - items on columns

Sum of sales that we created on values:

I attached the pbix , so you can download it and follow my steps

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi TITO22 
Open the drill options list and select "columns" 

and then drill down.
These options exist at all versions since 2017 🙂

For more informations please refer :

https://www.youtube.com/watch?v=qphVQdI5rQs

(from 3 minute)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly