topic Re: Calculate percentage in DAX Commands and Tips

Calculate percentage

dofrancis3 — Tue, 26 Nov 2024 08:57:15 GMT

Dear Team;

I would like to request your support.

How can i calculate the percentage? (Dax). In case I have the tables (1srt one OR second one) below :

Thank you

Kedar_Pande — Tue, 26 Nov 2024 09:01:34 GMT

Assuming you want to calculate the percentage of cases based on Gender in the first table:

Create measures:

Total Cases = SUM('YourTableName'[Case])

Total Cases Female = 
CALCULATE (
[Total Cases],
'YourTableName'[Gender] = "F"
)

Total Cases Male = 
CALCULATE (
[Total Cases],
'YourTableName'[Gender] = "M"
)

Percentage Female = 
DIVIDE (
[Total Cases Female],
[Total Cases],
0
)

Percentage Male = 
DIVIDE (
[Total Cases Male],
[Total Cases],
0
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

dofrancis3 — Tue, 26 Nov 2024 09:10:07 GMT

Dear Kedar_Pande Thank you for your replay but i would like to calculate only the percentage of total cases

bhanu_gautam — Tue, 26 Nov 2024 09:23:20 GMT

dofrancis3 , Try creating a measure like

Percentage of Total =

DIVIDE(

SUM('Table'[Total]),

CALCULATE(SUM('Table'[Total]), ALL('Table'))

) * 100

PBIX file attached with solution

powerbidev123 — Tue, 26 Nov 2024 09:25:31 GMT

Hi dofrancis3 , Do you mean you need values like for eg.

Age group F M

<60 ans 52% 48%

dofrancis3 — Tue, 26 Nov 2024 11:04:58 GMT

Dear bhanu_gautam Thank you but note that this is a Mesure it's not a column.

So, please how to calculate a percentage in case Total is a mesure

bhanu_gautam — Tue, 26 Nov 2024 11:12:20 GMT

dofrancis3 , Update measure as

Percentage of Total1 =

VAR TotalSum = [Total1] -- Assuming [Total1] is your measure

VAR GrandTotal = CALCULATE([Total1], ALL('Table'))

RETURN

DIVIDE(TotalSum, GrandTotal) * 100

Attached updated PBIX considering Total as measure