Count tickets based on filtered date

Question

Hi Guys,&nbsp;&nbsp;Requesting for your help... I wanted to have a dax that counts the ticket when a date is filtered. I am currently not using dax to filter dates.. I am only using 1 table for this and I am wondering why it is not filterning up.&nbsp;&nbsp;Hope you can help with this. :)&nbsp;Thank you.&nbsp;&nbsp;&nbsp;

robbevl · Answer

Could you please share some more information?Some sample data and a result you want to see?

icdns · Answer

Hi&nbsp;RobbeVL&nbsp;,&nbsp;For example I have list of tickets with "completed_date".&nbsp;Filter: Completed Date: August 1, 2019&nbsp;&nbsp;&nbsp;Ticket No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Completed Date001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;August 1, 2019002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; August 2, 2019003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;August 1, 2019&nbsp;&nbsp;Scenario: If August 1, 2019 is filtered, only Tickets 001 and 003 will reflect.&nbsp;&nbsp;I only have 1 table for this :)&nbsp;&nbsp;

robbevl · Answer

Hi there,&nbsp;I still dont really understand your question.What you describe seems like normal Beheviour.You could just insert a Slicer in your visual and filter on date.Or do you want a measure to do some calculation?&nbsp;Robbe

icdns · Answer

Hi&nbsp;RobbeVL&nbsp;,&nbsp;&nbsp;Yes it seems like an easy problem. I tried using slicer in my visual and filter on date but it's pretty weird it is not filtering up. Another solution that I can see is using a measure to do calculation :)&nbsp;&nbsp;Hope you could help me on this. Thank you :)

robbevl · Answer

You will need to create some sort of sample dataset... or pbix file

Forum Discussion

Count tickets based on filtered date

9 Replies

Related content

Cumulative count of ticket

DAX formula to count ticket status

Filter participant counts

Filter and Count

Submit ticket