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
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 -" }
)
- Marinus1 year agoHelper I
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