Forum Discussion

Marinus's avatar
Marinus
Helper I
1 year ago
Solved

COUNTROWS

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 -,...
  • Cookistador's avatar
    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 -" }
    )

     

  • Marinus's avatar
    Marinus
    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