Forum Discussion

jussiwaisto's avatar
jussiwaisto
Helper I
7 years ago
Solved

Basic DAX filtering won't work

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.

  • 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

2 Replies

  • tex628's avatar
    tex628
    Community Champion

    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