Forum Discussion
COUNTROWS
- 1 year ago
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 -" }
) - 1 year ago
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
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 -"
)