- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to calculate percentage using the result a of new Measure ?
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, try this:
MeasuretoUse =
DIVIDE([Nombre_Consultant],CALCULATE('02 Juin'[Nombre_Consultant], ALL('02 Juin'[STATUT ])))
Lima - Peru
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you put the original Table? that looks like a visualization
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry for disturbance you , but i need to know if there are any proposition.
Thanks 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can find my .pbix file on the below link :
https://1drv.ms/f/s!ArRlhOnGvzHibgygLcRz_xXmAas
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, try this:
MeasuretoUse =
DIVIDE([Nombre_Consultant],CALCULATE('02 Juin'[Nombre_Consultant], ALL('02 Juin'[STATUT ])))
Lima - Peru
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 03:35 PM | |||
05-08-2024 01:23 AM | |||
10-20-2023 10:27 AM | |||
Anonymous
| 07-20-2023 09:42 AM | ||
Anonymous
| 04-04-2024 11:38 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |