Basic filtering by using DAX

if your system uses semicolons as list separator then you should use it in the measures too

you can validate you syntax here:
https://www.daxformatter.com/

right now I'd suggest:
1) replacing commas with semicolons

2) the column name should be 

'ekoseer Sopimus'[SopimuksenTila]

I think there is an apostrophe missing before '[' 

hi, jussiwaisto 

You should use this simple formula as below:

Measure = 
CALCULATE([Id_sopimus_kpI],
                     'ekoseer Sopimus'[Id]="1")

and the column name should be 

'ekoseer Sopimus'[SopimuksenTila]  

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

Best Regards,

Lin

---

jussiwaisto wrote:

Hi, 

 

i'm trying to make very simple filtering by using DAX. The situation is this:

1. I have a table 'ekoseer Sopimus'

2. I have a measure, which counts how many Id's I have in table

 

Then I would like to count Id's which "'SopimuksenTila" is value "2". The result should be three.

I'm trying to make a new measure which uses measure Id_sopimus_kpl and filters it, but I can't make working syntax:

 

 

What is the right syntax?

 

I know this should be very simple, but for some reason my PowerBi changes commas to semicolons and syntax won't work. 

 

Thanks for helping!

---

jussiwaisto  

1. First you need to count the ID table

2. then, Calculate( <your measure> ,  your filter = "2" ) 

What i have seen is too many open ")" in your syntax.  

Thank you very much! It works now!