Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stop measures from repeating in matrix visual

Hello PBI experts,

 

I would like to know if the issue of measure repeating in matrix visual for each group/category has been resolved. The workaround is to resize the unwanted repeating measures, but it leaves the report look very untidy. Another workaround suggested on some post is to ues 'ISINSCOPE' function. I have tried to use this, but doesn't work to resolve repeating measures.

Here is an example: The measures highlighted in yellow are repeating for locations N & S and not wanted

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - I don't have an answer for this but very interested in this subject. Many times, users want the measure as a total but not in the column groups themselves. Have run into this kind of thing multiple times and haven't found an adequate fix so adding myself to this thread to see if someone else knows of a solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous 

    I'd like to suggest you add if statement to check current row contents level, than you can skip calculate on specific level items.  If whole row/column not has correspond records, matrix visual will hide this row/column.

    Clever Hierarchy Handling in DAX

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous thanks for your reply, but I can't figure out any hierarchy levels in my dataset.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        If you use multiple table fields in column/row fields, they can also work similarly to a hierarchy structure.

        In addition, you can also consider to create a custom column time table to replace original table fields, then write measure to use the current row and column to search corresponding results.

        Calculate table:

        Column Table =
DATATABLE (
    "Parent", STRING,
    "Child", STRING,
    {
        { "S", "S Billing" },
        { "S", "SC_Diff" },
        { "S", "Total" },
        { "N", "N Billing" },
        { "N", "NW_Diff" },
        { "N", "Total" }
    }
)

        Regards

        Xiaoxin Sheng