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

     

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

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