Forum Discussion

Icon for Helper IV rank

Helper 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 supporting date and text values

Anonymous

ok please try :

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

5 Replies

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
  Helper 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
    Not applicable
    3 years ago
    ok please try :
    
    Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50

Related content