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