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 -,Vlgr -,Rsdg -,Odzg -,Edng -,Bdlg -,Svgg -")

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

7 Replies

Replies have been turned off for this discussion
  • Cookistador's avatar
    Cookistador
    Super User
    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
      Helper I
      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

  • vivek31's avatar
    vivek31
    Resolver II
    1 year ago

    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.

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

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

  • praveen_511's avatar
    praveen_511
    Advocate I
    1 year ago

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