Forum Discussion

TITO22's avatar
TITO22
Frequent Visitor
2 years ago
Solved

Matrix, grouping column and rows

Hi everyone,

 

I want to use a matrix table with grouping column + grouping rows.

I have two table : ITEM table & SALES table

 

This is the result i'm looking for.

 

 

Can someone help me?

 

Regards,

TITO

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

5 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    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

    • TITO22's avatar
      TITO22
      Frequent Visitor
      2 years ago

      Thank you Ritaf1983. I tried your solution but I didn't get the same result as you. Could it be a version issue? I was unable to open your pbix on my Power BI desktop.

       

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User
        2 years ago

        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