Don't show subtotal for certain columns

[GAPER]

Can i not show some subtotal for specific columns? It's a matrix table. 

Thanks. 

[GAPER]

This is an example - I am foreced to use First(Country) / First(Sector) for the column because I don't need it to be on column but it's not actually a measure. The issue is that when it comes to the total row. It's showing non meaningful results and I would l like to hide the column Country and sector for the cells in total. 

Thank you

[vanessafvg]

as per my screenshot above did you check your visual settings?

[vanessafvg]

what do you have placed on your matrix?  can you please give more information, under column subtotals on your visual settings you do have an option to select certain columns as below.  if that isn't showing up as expected, then please post what you are placing on the matrix and where?

[GAPER]

Am i setting these correctly?

[danextian]

Hi @GAPER ,

You need to specify that in your formula. For example, if you want the subtotal for column A to be blank, you can write

= IF ( HASONEVALUE (table[ColumnA]), [my measure] )

This tells DAX to return  the value of mymeasure if ColumnA has been filtered down to one distinct value only. Please refer to this thread: https://community.fabric.microsoft.com/t5/Desktop/Remove-subtotal-from-only-one-column-in-a-Matrix-i...