Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
8 years ago
Solved

Calculating 2 variables

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

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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"
    )

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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"
    )