Forum Discussion

nicodeanto's avatar
nicodeanto
New Member
4 years ago
Solved

Hide Matrix Grand Total

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

Visual
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

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

     

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    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's avatar
      nicodeanto
      New Member
      4 years ago

      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;