Basic filtering by using DAX

[jussiwaisto]

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!

[Stachu · Accepted solution]

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 '[' 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

[v-lili6-msft · Accepted solution]

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

[Anonymous · Accepted solution]

---

@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.  

[Anonymous · Accepted solution]

---

@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.  

[jussiwaisto · Accepted solution]

Thank you very much! It works now!

[v-lili6-msft · Accepted solution]

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

[Stachu · Accepted solution]

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 '[' 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!