Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hello all,
Thank you for your help.
The issue has been resolved.
Kind regards,
Aaquib Islam
Hello all,
Thank you for your help.
The issue has been resolved.
Kind regards,
Aaquib Islam
Hi @Aaquib_Islam,
Please share a sample.
Best Regards,
Dale
Hi,
Share a dataset and show the expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |