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

     

     

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