Count matching rows for each date comparing with previous date

[lakshmanan]

Hi , 
i an new to PowerBI , I am trying to create a measure to count the id's if it is present in the previous date and Count Id's if not present in the previous date based on date slicer selection. Kindly help me on this.
Table1:

Date	Id
1/2/2021	3211
1/2/2021	4561
1/2/2021	3112
5/3/2021	4356
5/3/2021	3211
5/3/2021	4561
5/3/2021	3245
5/3/2021	3821
4/6/2021	5432
4/6/2021	3112
4/6/2021	3211
4/6/2021	3542

Slicer : Date
So, if slicer selects 5/3/2021 ,it should compare with 1/2/2021 and if slicer selects 4/6/2021 ,it compares with 5/3/2021.

Example: Slicer selected : 5/3/2021
Matching ID's count on 5/3/2021 =2 (Matched ID's =3211 & 4561)
Unmatching Id count on 5/3/2021 = 3 
Unmatching Id count on 1/2/2021 =1

i have achieved with calculated column , since slicer is used . i need to create the measures for the above to change based on slicer selection. Kindly help me 

[Anonymous]

Hi @lakshmanan,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.