Forum Discussion

v_mark's avatar
v_mark
Icon for Helper V rankHelper V
4 years ago
Solved

Count all the next day

I have a simple problem to solve hope you can help me out. 

Today is 1/10/2022.

I need to count all the entries that are greater than today with the status of "Closed" only as shown in the table below.
I was hoping to create 1 Calculated measure only that will satisfy the requirement.  

 

General Comment
Show and Tell
Tips and Tricks
  • smpa01's avatar
    smpa01
    4 years ago

    v_mark 

    Measure = COUNTROWS(FILTER('Table','Table'[Change Date]>TODAY()&&'Table'[State]="Closed"))

1 Reply

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    v_mark 

    Measure = COUNTROWS(FILTER('Table','Table'[Change Date]>TODAY()&&'Table'[State]="Closed"))