Show value as percentage of column total + Filter

[Hey]

Good Morning all... hope you are doing good

I have this simple report

The first object is simple treemap

The second one is a matrix. The value of the matrix is the following measure shows as % of Column Total,

BUDGET % = DIVIDE(CALCULATE(SUM('Rd''H Budget'[BUDGET])),

                                  CALCULATE(SUM('Rd''H Budget'[BUDGET]),

                                  ALLEXCEPT('Rd''H Budget','Rd''H Budget'[EXERCICE FISCALE 2]))

                                 ) 

What I want to do is: when I select an element of the treemap, the matrix should display the percentage of the element.

Right now, when I select an element, this is what happens, the matrix displays 100%

for the treemap element selected --> the matrix displays 100%

How to get the matrix to display the value as % of Column Total (Colum total: considering all the value in the treemap, not the selected one). Other said I want the value of the matrix to not change to 100%, but to still show the original value when none of the element in the treemap was selected.

Thank you for your help and your understanding!

Regards, 

[v-ljerr-msft]

Hi @Hey,

Could you post your table structures with some sample data which can help us to reproduce this issue? So that we can better assist on it. It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards