How to show only column subtotal in power bi table?

Question

I have a table like and I would like to see only the subtotal column. Is this even possible in power bi ?

davidebacci · Accepted Answer · 2023-11-15 12:15:59Z

1

Yes, it is possible. For your measure, you need to write it in the form:

IF(HASONEVALUE('Table'[ColumnwithC]), BLANK(), [yourmeasure])

answered Nov 15, 2023 at 12:15

davidebacci

31.4k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

is it also possible for matrix ? for that i need to create a new questions ?

Yes, it is possible in a matrix. I suggest you write a new question but provide either sample data or a sample .pbix to better help you.