Countrows only for the values that have a minor date than today

[Aydeedglz]

Hi I am trying to create a measure that ONLY will count the rows of the values in column "Date" that are minor than today. That means everything < Today. But the ones that I have created count everything, I don't know where the error is. I am going to display it by costumer.

Not working 

VAR A = CALCULATE(COUNTROWS(FILTER(TABLE1,TABLE1[DATE] < TODAY())))

VAR B = IF(VALUES(TABLE1[DATE]) < TODAY(), COUNTROWS(TABLE1), BLANK())

RETURN

COUNTROWS(FILTER(TABLE1,TABLE1[DATE] < TODAY()))

[Anonymous]

Hi @Aydeedglz 

Unfortunately, your dax works well in my side:

Maybe you can share your data(without sensitive data), or create a sample data.

How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @Aydeedglz ,

try the following measure

Measure = CALCULATE(COUNTROWS('TABLE1'),'TABLE1'[DATE] < TODAY())