need help with a count till today

[Krijgersss]

Hello i need some help i want to count rows till todays date

i now use 

Aantal rijen open dagen = DISTINCTCOUNTNOBLANK('newfysic warehouse_open'[date]) but this count rows and if i use a slicer i dont work i want that count but than till todays date so if we are going to tommorow it wil count till tomorow so i can make a future calculation based on 

revenu per day = revenu / days open 

and then 

future calculation = revenu per day * count days untill today

[govindarajan_d · Accepted solution]

Hi @Krijgersss ,

Can you try like this: 

CALCULATE(DISTINCTCOUNTNOBLANK('newfysic warehouse_open'[date]),'newfysic warehouse_open'[date] < TODAY())