Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago
Solved

Count rows in date table where date is ...

Hi guys   trying to count rows in date column. Simply I would like to get result as count rows where date is "20/07/2020" and muliply by 50.   I did try countrows but it gives error about not ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    ok please try :

     

    Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

thats weird can you try :

 

 

Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))) * 50

 

if this works please consider acceptig it as solution and kudos

 

  • MasterSonic's avatar
    MasterSonic
    Icon for Helper IV rankHelper IV
    3 years ago

    HI there,

    this bit works fine

    Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))

     but after adding 

    * 50

    I got this error
    A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      ok please try :

       

      Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50

       

       

      • MasterSonic's avatar
        MasterSonic
        Icon for Helper IV rankHelper IV
        3 years ago

        Thank You,

        verision with 

        COUNTX

        works  

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      i think you missed a bracket when closing the calculate please make sure

      Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))

      this should be 

      Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20)))