Forum Discussion
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...
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
Super User
Super UserHi,
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]
)
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;