topic Re: Count rows in date table where date is ... in DAX Commands and Tips

Count rows in date table where date is ...

MasterSonic — Fri, 28 Oct 2022 16:01:54 GMT

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 — Fri, 28 Oct 2022 16:40:55 GMT

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 — Fri, 28 Oct 2022 16:27:46 GMT

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 — Fri, 28 Oct 2022 16:38:37 GMT

ok please try :

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

Anonymous — Fri, 28 Oct 2022 16:41:53 GMT

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

MasterSonic — Fri, 28 Oct 2022 16:44:45 GMT

Thank You,

verision with

COUNTX

works