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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write this measure

Measure = countrows(filter(Data,Data[Call date]>Data[Delivery date]))

To your table visual, drag Account Number and this measure.

Memphis28's avatar
Memphis28
Frequent Visitor
2 years ago

Thank you for the help. I am still getting the same issue where it isn't referencing the correct delivery date based on the account. I get the following error:

If i enter Min or MAX to try and get around this error i get the same issue as before where it is adding all calls together and isn't dynamic based on the account. 
The data is coming from 3 different tables, all have relationships set up (correctly has far as i can tell) but could this be causing this issue?

Thanks in advance

M/28


  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Share the download link of the PBI file.