I’m new to PowerBI and I need to convert a couple of calculation from Tableau into PowerBI:

1. I need to calculate the total number of fields that were marked with an error for a specific user.
2. I need to calculate the total number of fields reviewed for a specific user.
3. I need to calculate the above two but cross all users.
4. I need to visualize top 5 fields with errors across all users.

Context: users work/update fields. The reviewers check those worked fields and mark with Error or No Error. We need to calculate the defect ratio between the fields marked with errors versus total fields reviewed for each user. Also, need to calculate the defect ratio overall across all users.

Thanks so much for all your help!!!!

In Tableau the calculations look like:

Defect ratio: 1-(SUM([No Error Count])/SUM([All Field Count]))

No Error Count: {FIXED [User],[ReviewDate], [ErrorType], [ReviewItemID]:SUM(IF [ErrorType]=”No Error” THEN 0 Else 1 END)}

All Field Count: {FIXED [User],[ReviewDate], [ReviewItemID]:COUNT([ErrorType])}

I tried putting dax together but didn’t get any meaningful results.