How to calculate percentage using the result a of new Measure ?

[mellas_k]

I have the below table and I need to calculate percentage:

 

To calculate the  8% ;13%;38%;41% you need to calculate (3/39)*100; (5/39)*100 ……

To calculate 30% and 70% you need to calculate (39/129)*100 ; (90/129)*100

For information Mesure is new measure ( Mesure =count (Table[colonne])) so I cannot calculate the Total of a new measure …

Someone please can help me to calculate the percentage that I need?

[ContabilidadBI]

Hi @mellas_k,

Have you tried to calculate "Mesure" as a calculated column?

[mellas_k]

HI @ContabilidadBI

yes , but it not work ...

[ContabilidadBI]

Can you put the original Table? that looks like a visualization

[mellas_k]

My original table : 

And I need to find the result of the percentage shown in my first post .

Mesure = Nombre_consultat 

Thanxs for your help 

[mellas_k]

Hi,@ContabilidadBI  

sorry for disturbance you , but i need to know if there are any proposition.

Thanks 🙂

[v-huizhn-msft]

Hi @mellas_k,

The screenshot is not the resource table, it's still a table visual. You'd better share your resource table by clicking table button(highlighted in red line), post it in a table rather than screenshot. So that we can reproduce your scenario.

Please create a visual using the following formula.

Percentage=SUM(Table[Nombre_Consultant])/CALCULATE(SUM(Table[Nombre_Consultant]),ALLEXCEPT(Table,Table[BU]))

Thanks,
Angelia

[mellas_k]

hi @v-huizhn-msft ,

Thank’s for your answer , I’m sorry but don’t found how to share my resource table can you please help me ..

And I cannot calculate   SUM(Table[Nombre_Consultant]) because [Nombre_Consultant] it 's a new measure  that i created .

Thanxs .

[v-huizhn-msft]

Hi @mellas_k,

You click the table button highlighted in red line, select the table in right field area.



If you don't mind, you can share your .pbix file in Onedrive and post the link.

Best Regards,
Angelia

[mellas_k]

hi @v-huizhn-msft

you can find my .pbix file on the below link :

https://1drv.ms/f/s!ArRlhOnGvzHibgygLcRz_xXmAas

Thanks for your help.

[Vvelarde · Accepted solution]

@mellas_k

Hi, try this:

MeasuretoUse =
DIVIDE([Nombre_Consultant],CALCULATE('02 Juin'[Nombre_Consultant], ALL('02 Juin'[STATUT ])))

[mellas_k]

Hi @Vvelarde

Thanks, it's work 🙂 

thanks for your help:)