Count of the rows with specific conditions

[Peter_2020]

Hello all, 

I would like to ask you for help with following situation:

I have table with data about production orders, which is combination of two tables - Person and Data. After activation of few filters table looks like this:

As you can see on PO 111111111 worked 2 operators - Steve and John. what I want to achieve is that after filtering of the data I will get one row with number of operators worked on specific PO:

For better understanding I am sharing example in pbix file:

Operators.pbix

Thank you for your help in advance. 

P.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = if(ISBLANK([Number of operators]),BLANK(),CALCULATE([Number of operators],ALLEXCEPT(Data,Data[PO])))

Hope this helps.

[Peter_2020]

It works! Thank you @Ashish_Mathur for your help.

[Ashish_Mathur]

You are welcome.