COUNTROWS

[Marinus]

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 -")

[techies]

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

[praveen_511]

@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 -"
)

[bhanu_gautam]

@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 -")
)

[vivek31]

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.

[Pow3Range]

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

[Cookistador · Accepted solution]

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 -" }
)

[Marinus]

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