Distinct count from another table on max date

Hi Sibrulotte - You need to follow a structured approach to ensure that you're considering only the clients that have transactions on the maximum date without duplication

Use the below measure

DistinctClientCountOnMaxDate = 

VAR MaxDateValue = [MaxDate]

RETURN

CALCULATE(

    DISTINCTCOUNT(Table2[Client]),

    FILTER(

        Table1,

        Table1[Date] = MaxDateValue

    )

)

 output:

 

 

 

can you please use the above logic and let know.

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!