Clustered column showing percentage completed of total based on row counts filtered

[evanjohan]

I need to show the percentage of inspected assets based on the total inspections needed from the second table filtred by year and div/mappage. All done with row counts of items. I'm sorry I don't know what correct syntax I need. But I need a clustered column that shows the percentage of asset inspections completed based on their Div number and year.

Thank you.

Table showing when an asset has been inspected by year and division..List of all planned asset inspections by year and mappage(DIV).Inspected Table I would like to show as a percentage of total inspections needed that have been completed. So 2019 should all show 100% while 2020 will show completed and increase as more are done.

[v-deddai1-msft · Accepted solution]

Hi @evanjohan ,

What is the logic to determine the planned item and inspected item? If it is decided by whether there is a value in the PassFail column, I suggest you use the following measure:

Measure = DIVIDE(CALCULATE(COUNT('Table'[INSPECTIONID]),FILTER('Table','Table'[PassFail] <>BLANK())), CALCULATE(COUNT('Table'[INSPECTIONID]),ALLEXCEPT('Table','Table'[YEAR],'Table'[DIV])))

If it doesn't meet your requirement, Could you please inform us more detailed information, such as your expected output and your sample data(by using OneDrive for Business) if possible? Then we will help you more correctly. Please don't contain any Confidential Information or Real data in your reply or files.

For more details, please refer to  https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETNPi0a8MdJCrh0LZT...

Best Regards,

Dedmon Dai