compare today date equal to another column date

[Anonymous]

How to compare (today date +1 equal to RequestClosedDate ) both are same return distinct count of Ticketno else 0

 i have tried 

Ticket-Closed-oneday =

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

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

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

RETURN

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

it's not working 

Could you help with me these questions?

Thankful

Rajesh

[Mariusz]

Hi @Anonymous 

Try this 

Ticket-Closed-oneday = 
VAR __tomorrow = TODAY() +1
RETURN 
    CALCULATE(
        DISTINCTCOUNT( 'Table'[Ticketno] ), 
        'Table'[RequestClosedDate] = __tomorrow
    )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hi @Mariusz  @amitchandak 

above you mentioned measures not working, its return blank value

suppose if i'm using column

Ticket-closed-oneday = IF ( TODAY ()+1 = DATE ( YEAR ( Taxone_SP1[RequestClosedDate]), MONTH ( Taxone_SP1[RequestClosedDate] ), DAY ( Taxone_SP1[RequestClosedDate] ) ),

Calculate(DISTINCTCOUNT(Taxone_SP1[Ticketno])),0)

it's showing duplicate ticket also,  but i need unique ticket ID

Thanks

Rajesh

[amitchandak]

@Anonymous , try like

CALCULATE(DISTINCTCOUNT('Table'[Ticketno]), FILTER('Table','Table'[RequestClosedDate] = today()+1))