How to delete a subtotal for a column ?

[Anonymous]

Hello, 

I have a matrix, but for 2 columns in the image (the last two columns), the result is wrrong, i don't want to show this result. Do you know how to fix this ? I want to delete 1 802 933 , 1680 172, and the others 1 900 000 in the subtotal 

I want too that the values are not present in an export  

Thank you 

[MFelix]

Hi @Anonymous,

How is this being calculated are this measures or just values from your model?

If you are using measures what is the sintax you are using?

[Anonymous]

Hello, 

There is two tables in the matrix : 

Table A with the first two columns of the matrix 

Year Element Value A Value B

2023 Main d'oeuvre 97k 0

2023 Teletransmission 0 219k

In Power Query, Value C is calculated by add Value A and Value B

The Table B is the total budget, the fifth column in the matrix 

Year Budget

2023 19m 

There is a join between Table A and B with Year 

The fourth column is calculated by Budget - Value C

I hope it'll help you