How to get result 1 ? not 3

[Augustas-ase]

Hello, my formula is: 

Dif.values. = COUNTROWS(

    FILTER(

        SALES,

        SALES[client type] = EARLIER(SALES[client type])

            && SALES[OperacijosId] = EARLIER(SALES[OperacijosId])

            && SALES[Data] = EARLIER(SALES[Data])

    )

) and i get result 3 but i want to get result 1 because client type, operacijosid and Data values ​​are same 

[Anonymous]

Hi @Augustas-ase ,

Please try below dax formula:

Dif.values. =
COUNTROWS (
    FILTER (
        ALL ( SALES ),
        SALES[client type] = EARLIER ( SALES[client type] )
            && SALES[OperacijosId] = EARLIER ( SALES[OperacijosId] )
            && SALES[Data] = EARLIER ( SALES[Data] )
    )
)

If it does not work, please provide a screenshot of the results you are expecting and desensitized example data, it is helpful for me to test.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Augustas1991]

the answer should be 1, I'm using three filters here, but each filter has the same information

[Anonymous]

Hi @Augustas-ase ,

Could you please provide the desensitized example data? it is very helpful for me to test.

Best regards,
Community Support Team_Binbin Yu

[Augustas-ase]

who can help?