Table Matrix visualization hide subtotal for all but top group

[Graham_Inners]

hello 

I have a matrix with Country, catagory and subcategory. I have a budget figure just for Country, so when a user drills down a level below country I would like to hide the budget figure :

so I just want to show the first 10,000,000 and hide all the other figures until the 'Mexico' and 21,000,000 figures. thanks for any help

[Graham_Inners]

hi @bhelou sorry must be missing something, same result:

am I correct using the Table[Field] for the HASONCEVALUE or should I somehow refer to the field used on the Matrix?

[bhelou]

Try this : 

Budget = IF(HASONEVALUE(Country), SUM('Table'[Budget]), BLANK())

[bhelou]

This measure will only display the budget value when the Country column is the only field in the matrix, and it will display blank for any other level of the matrix.

You can replace the Country column in the above expression with the actual name of the column you are using in your matrix for the country level. If you have multiple columns for the country level, you can use the && operator to add additional conditions to the IF statement.

Once you have created this measure, you can use it in your matrix in place of the original budget value.