DAX percentage column

[Anonymous]

Hi,

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

 Need help on this. 

ID	Country	NotOverdue	Overdue	NotOverdue % ???
1	Germany	6	2	Example formula:  (NotOverdue/Notoverdue+Overdue )*100
2	India	7	2
3	Norway	5	3
4	Italy	3	1
5	Canada	8	0
6	USA	7	0
7	UAE	6	1
8	UK	5	2
9	France	4	4

[themistoklis]

@Anonymous 

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 · Accepted solution]

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])

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

I hope this helps. 

Best regards

Mikelytics

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

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

Appreciate your Kudos