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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.