The equivalent to countifs in Excel

[Anonymous]

Hi all!

Have searched for days to find a solution to the task I have at hand without further luck. This is probably easy peasy for you guys out there, but I'm pretty new to this. I have a set of data from an Excel file loaded into the Power BI as the picture shows below.

What I wanna accomplish is a new table with the first column containing the projects as a distinct count.

The next column containing a count of how many OK's in the column Status it had for that distinct project and the column after that with a count of the Status NOK. The last column would be total counts of OK and NOK for that project, divide by the count of OK to get the percentage OK for that project.

Then again I'm guessing that I need a new table for this to be able to visualize %OK for each project, maybe there is a more clever way to do it.

It would be lovely if I had the same option for Department if possible.

All the help would be much appreciated.

[jthomson · Accepted solution]

Generally you want something like:

calculate(distinctcount(your table name),your criteria)