Count if Two Dates Match

[yashpace]

Hi All

I am trying to count Distinct ORDNUM if NewOrderDate = NewdispatchDate, I am trying this in KPI and I want to select NewOrderDate from the Filter.

=IF (

[NewOrderDate] = [NewDispatchDate] ,  Count ( DISTINCT ( ORDNUM ) )

)

TIA!!!

[yashpace]

Hi,

This is always giving Count by month level. I have three filters - NewOrderDate, Week(NewOrderDate), Month(NewOrderDate). When I select NewOrderDate I want a count for that day but instead, it is coming for the whole month.

Thanks