Forum Discussion
Total Column
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.
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.
This is my matrix;
And I would like to not so just the total for "Año"
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])
Hi,
I don't know why is not working fr me
Hi,
"Año" is a column, a hierarchy, and I've selected the year only
