Forum Discussion

Icon for Post Patron rank

Post Patron

7 years ago

Count tickets based on filtered date

Hi Guys, 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 ...

Icon for Impactful Individual rank

Impactful Individual

7 years ago

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

icdns
Post Patron
7 years ago
Hi RobbeVL ,

For example I have list of tickets with "completed_date".

Filter: Completed Date: August 1, 2019

Ticket No Completed Date
001 August 1, 2019
002 August 2, 2019
003 August 1, 2019

Scenario: If August 1, 2019 is filtered, only Tickets 001 and 003 will reflect.

I only have 1 table for this :)
- RobbeVL
  Impactful Individual
  7 years ago
  Hi there,
  
  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?
  
  Robbe
  - icdns
    Post Patron
    7 years ago
    Hi RobbeVL ,
    
    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 :)
    
    Hope you could help me on this. Thank you :)
- Anonymous
  Not applicable
  7 years ago
  hi icdns
  
  here, i am sharing my screenshots plz check it.
  
  regards,
  Naveen
  - icdns
    Post Patron
    7 years ago
    Hi, Anonymous
    
    Yes yes this is correct, are you using a measure for this? Cause a simple filter can't solve my problem here :(

Related content