Forum Discussion

Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago
Solved

Count entries after a date

Good afternoon I am looking for a little guidance on something and fingers crossed someone can support. I have data that contains a scheduled delivery date, the data also shows the  dates the c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Memphis28 ,

    I create a table as you mentioned.

    Then I create a measure and here is the DAX code.

    Calls made after date =
VAR _currentAN =
    SELECTEDVALUE ( 'Table'[Account Number] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALL ( 'Table' ), 'Table'[Account Number] = _currentAN )
    )

    Finally you will get what you want.

     

     

     

    Best Regards

    Yilong Zhou

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

Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago

What may be of value but i am unsure is that the calls all have a qunique call reference ID in a seperate column if that makes it easier to count the individual calls coming in.