Hide Matrix Grand Total

[nicodeanto]

Hi Experts,

I have a matrix visual and I want to hide the Grand Total for the Total Machines and Totdal Day(s) (see snip) but I want to display for others. Please any advice on it.

Column visual is daily basis, so i can't add shape for hiding those total, because the posistion is dynamic.

Questions; Can those grand total be hidden?

Warmest Regards,

Nico

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your dataset looks like, but please try to write a new measure something like below and replace it with the current measure whether it suits your requirement.

New measure: =
IF (
    HASONEVALUE ( table[columnBGAA1others] ) && HASONEVALUE ( table2[column18] ),
    [yourcurrentmeasure]
)

[nicodeanto]

But thanks @Jihwan_Kim 
I already found the solution, just changed && to || 😁

[nicodeanto]

Hi Kim,

I have these structure;

Rack, Status, Day for visual.

I'm using RACK on Rows and DAY on Columns and SUM(STATUS) for the value; it's only BLANK, 0 and 1

I need to sum daily and by rack but no need to show CORNER grand total  as i mentioned before.

I tried this;

MTotal =

IF (

    HASONEVALUE ( 'ALL'[RACK] ) && HASONEVALUE ( 'ALL'[DAY] ),

    SUM('ALL'[STATUS])

)

but it's return to blank on total;