cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

DAX percentage column

Hi,

how to get a percentage column as NotOverdue. Example formula given below.

 Need help on this. 

 

IDCountryNotOverdue       Overdue          NotOverdue % ???
1Germany62Example formula:  (NotOverdue/Notoverdue+Overdue )*100
2India72
3Norway53
4Italy31
5Canada80
6USA70
7UAE61
8UK52
9France44
1 ACCEPTED SOLUTION
Resolver III
Resolver III

Hi MuraliPrasathS,

 

Please fin below y possible solution.

 

Step 1) Create a calculcated column with the following formula (my table is named t_2).

 

percentage not overdue = t_2[NotOverdue]/(t_2[NotOverdue]+t_2[Overdue])
 
picture 1.PNG

 

Step 2) Change the format of the column to percentage.

picture 2.PNG

 

I hope this helps. 

 

Best regards

Mikelytics

 

----------------------------------------------------------------------------------

 

Did I answer your questions? Please mark my post as solution.

 

Appreciate your Kudos

View solution in original post

2 REPLIES 2
Super User II
Super User II

@MuraliPrasathS 

 

You can also use the divide function in a calculated column:

Column = DIVIDE('Table'[NotOverdue], 'Table'[Notoverdue]+'Table'[Overdue])

 

In a measure you can use the following formula:

Column = DIVIDE(SUM('Table'[NotOverdue]), SUM('Table'[Notoverdue])+SUM('Table'[Overdue]))

 

And then change the format of the column to Percentage

 

Resolver III
Resolver III

Hi MuraliPrasathS,

 

Please fin below y possible solution.

 

Step 1) Create a calculcated column with the following formula (my table is named t_2).

 

percentage not overdue = t_2[NotOverdue]/(t_2[NotOverdue]+t_2[Overdue])
 
picture 1.PNG

 

Step 2) Change the format of the column to percentage.

picture 2.PNG

 

I hope this helps. 

 

Best regards

Mikelytics

 

----------------------------------------------------------------------------------

 

Did I answer your questions? Please mark my post as solution.

 

Appreciate your Kudos

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors