Stop measures from repeating in matrix visual

[Anonymous]

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

[SheetalP2403]

Anybody has any solution for this issue ?

[v-shex-msft]

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]

@v-shex-msft thanks for your reply, but I can't figure out any hierarchy levels in my dataset.

[v-shex-msft]

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

[Greg_Deckler]

@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.