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...
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"
    )
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"
    )
  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    8 years ago

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