Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
GeorgeColl
Helper II
Helper II

Calculate percentage using two count columns by year

I have searched for a solution but can't seem to get them to work in my specific situation.

 

I have two columns that I'm using: a count for the number of claims in one column and a second column is a count of the number claims that have had someone appointed to them, I then have this shown by year. I want to have a column showing the percentage of claims that have had someone appointed to them. Example table below is what i'm looking for including the % Appointed column I want to calculate. I have added an example of the data table below

 

YearCount of ClaimRefCount of appointed% Appointed
20171001010%
20181010

100%

20191001010%
2022402050%
Total2505020%

 

Any help would be much appreciated

 

EDIT:

 

 The table I've shown above was my desired output. My data table would look like the following:

 

ClaimRefYearAppointed
12342020Name1
12352021Name2
12362020 
12372021 
12382022Name3

 

In my output table (being shown in the report) I'm using a count of ClaimRef and a count of appointed (i.e. the claims where someone is appointed). 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

You can add a new column with the code below:

 

% Appointed = FORMAT(DIVIDE('Table'[Count of appointed],'Table'[Count of ClaimRef]),"00%")

View solution in original post

2 REPLIES 2
GeorgeColl
Helper II
Helper II

Sorry if it wasn't clear, the table I've shown was my desired output. My data table would look like the following:

 

ClaimRefYearAppointed
12342020Name1
12352021Name2
12362020 
12372021 
12382022Name3

 

In my output table (being shown in the report) I'm using a count of ClaimRef and a count of appointed (i.e. the claims where someone is appointed). 

FreemanZ
Super User
Super User

You can add a new column with the code below:

 

% Appointed = FORMAT(DIVIDE('Table'[Count of appointed],'Table'[Count of ClaimRef]),"00%")

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.