cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Aaquib_Islam Frequent Visitor
Frequent Visitor

Calculating the average completion across duplicate items

I have a column with a number of duplicate ID’s and a column with percentages, which signifies percentage completion per item i.e. 0%, 25%, 50%, 75% and 100% complete.

 

I want to work out the average % complete per “unique” item.

 

I have used the distinct count function in a measure to show only distinct values and added up the percentages for each unique ID. But, now, I think I need to work out how many times each duplicate ID occurs, so, I can use it to divide my rolled up percentages?

 

I am new to Power BI and any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Aaquib_Islam Frequent Visitor
Frequent Visitor

Re: Calculating the average completion across duplicate items

Hello all, 

 

Thank you for your help. 

 

The issue has been resolved. 

 

Kind regards, 

Aaquib Islam

3 REPLIES 3
Super User
Super User

Re: Calculating the average completion across duplicate items

Hi,

 

Share a dataset and show the expected result.

Community Support Team
Community Support Team

Re: Calculating the average completion across duplicate items

Hi @Aaquib_Islam,

 

Please share a sample.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aaquib_Islam Frequent Visitor
Frequent Visitor

Re: Calculating the average completion across duplicate items

Hello all, 

 

Thank you for your help. 

 

The issue has been resolved. 

 

Kind regards, 

Aaquib Islam