Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Total 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  
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

HI afrutos ,

 

Turn total option off from visualization pane.:-

Thanks,

Samarth

afrutos's avatar
afrutos
Resolver I
4 years ago

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