topic Re: Hide Matrix Grand Total in DAX Commands and Tips

Hide Matrix Grand Total

nicodeanto — Thu, 18 Aug 2022 07:25:36 GMT

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

Re: Hide Matrix Grand Total

Jihwan_Kim — Thu, 18 Aug 2022 07:26:13 GMT

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] )

Re: Hide Matrix Grand Total

nicodeanto — Thu, 18 Aug 2022 07:55:08 GMT

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;

Re: Hide Matrix Grand Total

nicodeanto — Thu, 18 Aug 2022 08:14:32 GMT

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