DAX - Count of Fields with Same Data

[spandy34]

Hi

I wondered if you could help.  I am wanting to calculate the SSRefs where the Planned Entry Time equals Delivered Entry time AND Planned Exist time equals Delivered Exit time .  The fields are in time format.

I did the code below but got an error saying the following.  Please can someone help.

Planned equals delivered exact =

CALCULATE(
COUNT('Procurement_Main_Data'[SSRef]),
'Procurement_Main_Data'[PlannedEntryTime]='Procurement_Main_Data'[DeliveredEntryTime] &
'Procurement_Main_Data'[PlannedExitTime]='Procurement_Main_Data'[DeliveredExitTime])

@tamerj1 @mlsx4 @pankaj_lp @Greg_Deckler 

[Pragati11]

HI @spandy34 ,

Can you please share the screenshots for all the four columns that they have a time datatype from Power BI?

[spandy34 · Accepted solution]

I think the following has worked:-

z_Exact Match =

COUNTROWS(

    FILTER(

        'Procurement_Main_Data',

        'Procurement_Main_Data'[PlannedEntryTime]= 'Procurement_Main_Data'[DeliveredEntryTime] &&

        'Procurement_Main_Data'[PlannedExitTime] = 'Procurement_Main_Data'[DeliveredExitTime])

    )