Calculating 2 variables

[RvdHeijden]

I hope someone can help me.

I have a table in which we have a lot of orders and a certain value.

To put it simple i need a formula that does the following.

I want the amount of orders i have in a certain City that have a certain value.

For example i want the number of orders with the status 'Actief' in 'Amsterdam'

Pretty simple right ?

I made a 'new table' with 3 colums

Column A ] unique value of City based on info from another Table (using summarize)

Column B] the number of adressen in City Column A

Column C] the number of Active clients in City Column A.

How can i calculate the value of Column C ? i need to look in the table 'EFOS' (detailled table) 

Here you see the new table i made and the colum 'Aantal Actief' has the error in it.

On the right you see a part of the other table

[Zubair_Muhammad · Accepted solution]

HI @RvdHeijden

Try this one with small modification

Aantal Actief =
VAR myPlaats = Woonplaats[plaats]
RETURN
    CALCULATE (
        COUNTROWS ( EFOS ),
        EFOS[Plaats] = myPlaats,
        EFOS[Adres status] = "Actief"
    )

[RvdHeijden]

@Zubair_Muhammad it looks like that did the trick, im going to crosscheck it but it looks good