topic Re: COUNTROWS in DAX Commands and Tips

COUNTROWS

Marinus — Thu, 27 Mar 2025 12:51:41 GMT

I want to count the rows with a specific combination.

Can you tell me wat is wrong in my code?

CALCULATE(

COUNTROWS('Overzicht aanvragen'); Overzicht aanvragen[Aanvraag_Routelint] = "Zvg -,Vlgr -,Rsdg -,Odzg -,Edng -,Bdlg -,Svgg -")

Re: COUNTROWS

Cookistador — Thu, 27 Mar 2025 13:28:49 GMT

Hello Marinus

I guess you need to count rows where Aanvraag_Routelint is Zvg -OR Vlgr -OR Rsdg - OR Odzg -OR Edng - OR Bdlg - OR Svgg -"

If I'm right, you have to use IN feature, so you code should become

CALCULATE(
COUNTROWS('Overzicht aanvragen'),
'Overzicht aanvragen'[Aanvraag_Routelint] IN { "Zvg -", "Vlgr -", "Rsdg -", "Odzg -", "Edng -", "Bdlg -", "Svgg -" }
)

Re: COUNTROWS

Pow3Range — Thu, 27 Mar 2025 13:24:32 GMT

Hi Marinus
Could you please let me know what error you encountered?

Re: COUNTROWS

vivek31 — Fri, 28 Mar 2025 05:59:21 GMT

HI Marinus ,

you can use this formula -
CALCULATE(COUNTROWS('Overzicht aanvragen'),
'Overzicht aanvragen'[Aanvraag_Routelint]

IN {"Zvg -", "Vlgr -", "Rsdg -", "Odzg -", "Edng -", "Bdlg -", "Svgg -"}
)

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Re: COUNTROWS

bhanu_gautam — Sat, 29 Mar 2025 04:27:07 GMT

Marinus The CALCULATE function in DAX is used to modify the context in which data is evaluated, but the syntax you are using for the filter condition is not correct. You should use the FILTER function to specify the condition within CALCULATE

CALCULATE(
COUNTROWS('Overzicht aanvragen'),
FILTER('Overzicht aanvragen', 'Overzicht aanvragen'[Aanvraag_Routelint] = "Zvg -,Vlgr -,Rsdg -,Odzg -,Edng -,Bdlg -,Svgg -")
)

Re: COUNTROWS

praveen_511 — Sat, 29 Mar 2025 19:06:54 GMT

Marinus Your DAX formula has a syntax error, as semicolons (;) are being used instead of commas (,), which are the correct parameter separators for functions in DAX. Additionally, the specific combination condition for Overzicht aanvragen[Aanvraag_Routelint] isn't properly defined for a multi-condition comparison.

The corrected DAX :
CALCULATE(
COUNTROWS('Overzicht aanvragen'),
'Overzicht aanvragen'[Aanvraag_Routelint] = "Zvg -, Vlgr -, Rsdg -, Odzg -, Edng -, Bdlg -, Svgg -"
)

Re: COUNTROWS

techies — Sun, 30 Mar 2025 16:16:23 GMT

Hi Marinus do you want to match entire string ? or partial match?

Re: COUNTROWS

Marinus — Thu, 03 Apr 2025 12:38:48 GMT

I hope you can help me with my next question.

I have this code :

CALCULATE(
COUNTROWS('Overzicht aanvragen'),
'Overzicht aanvragen'[Aanvraag_Routelint] IN { "Zvg", "Vlgr", "Rsdg", "Odzg", "Edng", "Bdlg", "Svgg" }
)

This way i count only the rows with these texts in it, but now i want to count the rows without these specific texts in it.

I hope you can help me.

With regards

Marinus Schouten