Matrix Visual : Not-show the total for one of the measures

[Anonymous]

Its a matrix report

 We do not want to show the value in Grand total row for Target, as mentioned in the pic.

[Anonymous]

Please help why the report is showing wrong total for a simple report.

[v-lili6-msft]

hi, @Anonymous

After my research, it could achieve by custom format Settings for one measure of the measures.

But you may try this way:

Use ISFILTERED or HASONEVALUE() to create a new measure for this measure

for example:

Measure = IF(ISFILTERED(Areas[AREA]),[Distribution])


Measure 3 = IF(HASONEVALUE(Areas[AREA]),[Distribution])

Result:

Best Regards,

Lin

[Anonymous]

Sorry Lin, I am facing an issue that when I select a value in Slicer it starts showing the value.again in total row.

Measure =  IF(ISFILTERED('Book by week by line'[Site]),[Target])

[v-lili6-msft · Accepted solution]

HI, @Anonymous

Yes, if you select a value in slicer, ISFILTERED and HASONEVALUE() will return true() and show the value.again in total row.

So you could continue to add a step like this:

for the slicer in this matrix visual, add a new field for it and use it as a slicer

or use the new field as matrix Rows Value.

For example:

add a new AREA column

New AREA = Areas[AREA] 

Then drag it into slicer and select value from it.

Best Regards,

Lin

[Anonymous]

Even if it does not work then use the visual level filters instead of page level or report level filters.