cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MuraliPrasathS
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
Mikelytics
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
themistoklis
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

 

Mikelytics
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors