Forum Discussion
Resolver ITotal Column
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
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.
9 Replies
Samarth_18Community Champion
afrutosbut what if I want to take the rest of totals but not for the date?
- 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"- 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])
v-henryk-mstfCommunity Support
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.
