Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
Solved! Go to 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 '['
Proud to be a Datanaut!
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!
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 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!
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!
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
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 '['
Proud to be a Datanaut!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |