hide grand total but show row subtotals

[pot0to]

I have a matrix visual with two fields under the Rows section. I would like to keep the row subtotals, but hide the grand total. How can I accomplish this?

[v-zhangti · Accepted solution]

Hi, @pot0to 

You can try the following methods.

Measure = Var _Sum=SUM('Table'[Has Binary Content])
Return
IF(HASONEVALUE('Table'[DropDownName]),_Sum,BLANK())

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@pot0to , Refer if this can help

How to selectively hide rows in Power BI from a particular level | isinscope | Power BI Tutorials: https://youtu.be/Q9nH6lW0ZFs