Total Column

[afrutos]

Hi everyone,

I wondering if I can remove the total column, because it makes no sense to have a total for a date in this matrix

thanks in advanced

[v-henryk-mstf · Accepted solution]

Hi @afrutos ,

According to your description, you can replace the original field by creating the following measure. Refer to the following.

M_ =
IF ( HASONEVALUE ( Tab_[Category] ), MAX ( Tab_[Year] ), BLANK () )

If the problem is still not resolved, please point it out and provide test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@afrutos  That looks like a strange matrix - what does your raw data table look like? Seems like you might benefit from doing a bit of cleaning and filtering in Power Query. 

Otherwise, you could filter on this visual and select all of whatever column you're using in 'columns' of the matrix and then untick the [total ayuda] column.

[afrutos]

This is my matrix;
And I would like to not so just the total for "Año"

[ERD]

@afrutos , "Año": is it a measure or a column?

[afrutos]

Hi,
"Año" is a column, a hierarchy, and I've selected the year only

[AllisonKennedy]

@afrutos That makes more sense, you can create a measure for Ano:

Ano = SELECTEDVALUE(Ano) 

and use that in the matrix.

Or: 

IF(ISINSCOPE(Tablename[columnname used in matrix rows] ), [Ano])

[afrutos]

Hi, 
I don't know why is not working fr me

[Samarth_18]

HI @afrutos ,

Turn total option off from visualization pane.:-

Thanks,

Samarth

[afrutos]

but what if I want to take the rest of totals but not for the date?