Count occurences with several conditions

[ALEX13]

Hi, 

I have the following challenge for Power BI:

I want to count the number of "Orders" with a Result different to "Realizado", but with the following conditions:

• If an "IC Client" has one "Order" with a result equal to "Realizado", it shouldn´t be considered into the count.
• if an "IC Client" has more than 3 "Orders" with a result different to "Realizado" it shouldn´t be considered into the count.

For example:

Order	IC Client	CUP	Fecha inicio extrema	Result
13833842	10000028	ES02341500157	11/02/2018 0:00	Imposible realizar
13864396	10000028	ES02341500157	27/02/2018 0:00	Innecesario
13759224	10000030	ES02341500223	16/01/2018 0:00	Imposible realizar
13727349	10000072	ES023411gg0TJ	29/12/2017 0:00	Imposible realizar
13727345	10000072	ES023411gg0TJ	30/12/2017 0:00	Imposible realizar
13728120	10000072	ES023411gg0TJ	03/01/2018 0:00	Imposible realizar
13733794	10000072	ES023411gg0TJ	05/01/2018 0:00	Imposible realizar
13722089	10000125	ES023415257DF	28/12/2017 0:00	Imposible realizar
13878184	10000125	ES023415257DF	01/03/2018 0:00	Realizado

For this example, the count of "Orders" with the conditions would be equal to 3 ("IC client"= 10000028 with "Order"=13833842 and 13864396;"IC client"=10000030 with "Order"=13759224).

Thank you very much in advance.

[Zubair_Muhammad]

@ALEX13

But this IC Client  1000002806 has third row equal to Realizado

Why is it considered while 10000125 is ignored?

[ALEX13]

Hi Zubair_Muhammad, you are right. My mistake in posting the example table. I fixed it.

[Zubair_Muhammad]

Hi @ALEX13

Why is this client ignored??

10000030

[ALEX13 · Accepted solution]

Also right. Fixed.