How to Calculate Unique Ticket No

[Anonymous]

How to Find   (today +2 days equal to Due Date )  condition true   count of Unique Ticket ID

i tried 
ticket-2days = IF ( TODAY ()+2 = DATE ( YEAR ( Table[DueDate]), MONTH ( Table[DueDate] ), DAY ( Table[DueDate] ) ), CALCULATE(DISTINCTCOUNT(Table[Ticketno])), 0 )

[harshnathani]

HI @Anonymous ,

Try
ticket-2days = CALCULATE(DISCTINCTCOUNT('Table'[Ticketno]), FILTER('Table', 'Table'[Due Date] = TODAY ()+2 ))

If this does not work, please share some sample data.

Regards,

Harsh Nathani

[Anonymous]

@harshnathani    it's Not Working

Please Click here   Sample Data

Thanks

[harshnathani]

Hi @Anonymous ,

Try this.

Create a new Calculated Column

DueDate_Wo_TS = DATE(YEAR('Table'[DueDate]),MONTH('Table'[DueDate]),DAY('Table'[DueDate]))

Pull the Calculated Column and Ticket ID (Summarize Ticket ID by Distinct Count) and do a relative Date Filtering of the Visual.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani   it's working now 

Now the result is                                                                         
   But I need  like this

  

based on the Above result only     i have another calculation are there that's why im asking

[harshnathani · Accepted solution]

Hi @Anonymous ,

Try Measures

Today Tckts =

var _DAY = DAY(MAX('Table'[DueDate]))

var _MONTH = MONTH(MAX('Table'[DueDate]))

var _YEAR = YEAR(MAX('Table'[DueDate]))

RETURN

CALCULATE(DISTINCTCOUNT('Table'[TicketID]), FILTER('Table',DAY(TODAY()) = _DAY && MONTH(TODAY()) = _MONTH && YEAR(TODAY()) = _YEAR))

Today+1 Tckts =

var _DAY = DAY(MAX('Table'[DueDate]))

var _MONTH = MONTH(MAX('Table'[DueDate]))

var _YEAR = YEAR(MAX('Table'[DueDate]))

RETURN

CALCULATE(DISTINCTCOUNT('Table'[TicketID]), FILTER('Table',DAY(TODAY()+1) = _DAY && MONTH(TODAY()) = _MONTH && YEAR(TODAY()) = _YEAR))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani 

Thanks for your Support

It's Not working me ,  but there's No error, 

I Don't know what is the issue  Herewith i have attachhed PBIX file Click here ,  Could you Please Check?

Thanks  & Regards,

Rajesh

[harshnathani]

Hi @Anonymous ,

You request close date does not have any dates which are today.

Is it request close date or due date.

Regards,
Harsh Nathani

[Anonymous]

Hi @harshnathani 

Request Due Date

[harshnathani]

@Anonymous ,

Your measure has closed date. Pls check

Regards,

Harsh Nathani