Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to apply a filter only for rows at a matrix visualization

I need a filter that is only applied to the rows, but not to the columns of a matrix. It's possible?

  • Anonymous's avatar
    Anonymous
    4 years ago

    For example, I have this table without any filter applied: 

    And with a normal filter, it will only appear the products which has a client with an amount in the "Risk" segment:

    But, what I need is that only Clients to be filtered and see all the products available. Like this:

    It is for a white space analysis, to see which products are not sold to the clientes of certain industries or segments.

     

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Here's my solution.

    Sample data

     

    1.Create a calculated table to get the Product Number.

     

    2.Create a measure to return the results.

    Measure = IF(MAX('Table'[Product]) in ALLSELECTED('Table 2'[Product]),SUM('Table'[Value]),0)

     

    3.The matrix is created by the [Clients], [Product] in the main table measure. The slicer is created by the [Product] 

    in the new calculated table.

    When the slicer is filtered, all product numbers still exist.

     

     

    Best Regards,

    Stephen Tao

     

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

4 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member

    Hi Anonymous ,

     

    Can you provide an example of what you want to achieve?

     

    Thanks,

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    For example, I have this table without any filter applied: 

    And with a normal filter, it will only appear the products which has a client with an amount in the "Risk" segment:

    But, what I need is that only Clients to be filtered and see all the products available. Like this:

    It is for a white space analysis, to see which products are not sold to the clientes of certain industries or segments.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

       

      Here's my solution.

      Sample data

       

      1.Create a calculated table to get the Product Number.

       

      2.Create a measure to return the results.

      Measure = IF(MAX('Table'[Product]) in ALLSELECTED('Table 2'[Product]),SUM('Table'[Value]),0)

       

      3.The matrix is created by the [Clients], [Product] in the main table measure. The slicer is created by the [Product] 

      in the new calculated table.

      When the slicer is filtered, all product numbers still exist.

       

       

      Best Regards,

      Stephen Tao

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        Thanks very much! It works perfectly. Only one doubt, is it possible to put a conditional in that measure?