Need Urgent help on table visual dynamically to display the required records.

Hi mg00842082 ,

We can be divided into two steps to operate, the first step is to mark duplicates, we use the first variable A to determine whether there are duplicates in our data, and then the second step begins to ask for duplicates of our customer ID, set to greater than 1, so that 10005001 excluded, and then finally applied to our filters to filter out the value of 0, you can achieve your needs!

DuplicateFlag = 
VAR A =
   CALCULATE(
       COUNTROWS('customer_data'),
       ALLEXCEPT('customer_data', 'customer_data'[First Name], 'customer_data'[Last Name], 'customer_data'[Gender], 'customer_data'[DOB])
   )
VAR UniqueCustomerIDCount =
   CALCULATE(
       DISTINCTCOUNT('customer_data'[Customer ID]),
       ALLEXCEPT('customer_data', 'customer_data'[First Name], 'customer_data'[Last Name], 'customer_data'[Gender], 'customer_data'[DOB])
   )
RETURN
IF(A >=2 && UniqueCustomerIDCount > 1,
 1, 
 0)

If you need to show the data of 10005001 on another page, we can try to add a buttons to realize a jump to our other interface.

I hope my answer is helpful, you can check the pbix file I uploaded if you still have questions, if you have further questions you can always contact me and I will reply the first time I see a message!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.