How to calculate a percentage relative to a column

[Lefuneste57]

Hi, i have a table "POPI" like this :

And i want a mesure (Column %percent) who calculate the % of surface value per Town like this :

Thanks for your Help.

[Pow3Range · Accepted solution]

Percent =

VAR SUM_ = SUM('Data'[Surface])

VAR CLIENT_E =  CALCULATE(

        SUM('Data'[Surface]),

        ALLSELECTED('Data'[Client]))

 RETURN

DIVIDE(SUM_,CLIENT_E)

[Lefuneste57]

Hi, Thank you.

It work fine ! 😉

[Pow3Range]

Thanks!!!👍😊

[lbendlin]

[Lefuneste57]

Hi, thanks for answer.

But i need to be able to remove certain Client. And when I do this, the formula no longer works.

For exemple, if i remove the client "RET" the percent is not 100%.

 

If you have a solution.. Thank you for help.