Calculating the average completion across duplicate items

[Aaquib_Islam]

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.

[Aaquib_Islam · Accepted solution]

Hello all, 

Thank you for your help. 

The issue has been resolved. 

Kind regards, 

Aaquib Islam

[v-jiascu-msft]

Hi @Aaquib_Islam,

Please share a sample.

Best Regards,

Dale

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.