Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost 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 ...
Need Help
icdns's avatar
icdns
Icon for Post Patron rankPost 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 :) 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi icdns 

 

here, i am sharing my screenshots plz check it.

 

regards,

Naveen

  • icdns's avatar
    icdns
    Icon for Post Patron rankPost 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 :(

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hi icdns ,

       

      I am not using any measures here, simply drag and drop the columns only.

       

      Regards,

      Naveen

  • RobbeVL's avatar
    RobbeVL
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    But what do you want to see?
    How many Tickets in a day?

    if so: Make it into a Matrix table, Drag "Date" to rows, and "Ticket no" to value, and make sure it Counts the column.