Count all with filter from another table (active contacts with active account in sweden)

[Anonymous]

Hi 

I am trying to create a measure that count all active contacts with a related active account where account country equals sweden

I am able to count all contacts but I get error when I try to add account filter. 

Measure antall kontakter = COUNTROWS(FILTER(Contact;Contact[statuscode]=1 ))

I assume I must add (FILTER(Account;Account[statuscode]=1 ) and (FILTER(Account;Account[Country]="sweden" ) but I cant get it to work.

Can someone plase help me with the syntax? 

Many thanks for any help!

[Nathaniel_C]

Hi @Anonymous ,

Would you share a picture of your model, or a mockup? Are the tables related?

Nathaniel

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

You will probably end up with something like this.

Calculate (countrows(Table),  Column = 1 , Column = "Sweden")

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Thanks for your answer!

I think this will work. One issue was I had to use ; instad of ,