Basic DAX filtering won't work

[jussiwaisto]

Hi,

i'm trying to make very simple DAX filtering, but for some reason my syntax won't work.

I have a table which name is 'ekoseer Sopimus'.

Then i made a measure which counts how many Id's there are (result is 7).

Then I'm making new measure, which should count how many Id's I have where [SopimuksenTila] is 1. Result should be 4. 

This is my syntax I tried, but it doesn't work, what I do wrong?

(For some reason when I use comma, PowerBi changes it to semicolon. Is there different versions of syntax or why is that?)

Thanks for helping.

[tex628 · Accepted solution]

It looks like you are using the wrong delimiter, replace the "," with a ";" and see if it works. 

Europe use ";" while US use "," 

Gl,
J

[jussiwaisto]

Thanks, got it! So simple. 😄