Count rows in date table where date is ...

[MasterSonic]

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

[eliasayy]

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]

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.

[eliasayy]

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

[eliasayy · Accepted solution]

ok please try :

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

 

[MasterSonic]

Thank You,

verision with 

COUNTX

works