Show Duplicates With Respect To Page Slicer

[sv98917n]

Hello PowerBI Community, 

I am currently facing an issue with my duplicate ID flag. While the DAX flag works for the whole report, it does not show values in accordance with my [created_date] date slicer. Yes, I do have a page level filter, but it does not change the DAX responces. So when I select a date range based on the created date, it says "Yes" to values that are duplictaes for the whole report range, but not the sliced range. 

This is my duplicate flag. I need something that incorprates the slicer based on [created_date]. Any help would be greatly appreciated. 

Duplicate Segment ID =

IF (

COUNTROWS ( FILTER ( table1, table1[SEGMENT_ID] = EARLIER ( table1[SEGMENT_ID] ) ) )

>= 2,

"YES",

"NO"

)

[amitchandak · Accepted solution]

@sv98917n , Try a measure like. It will depend on rows context

Duplicate Segment ID =
IF (COUNTROWS ( FILTER ( allselected(table1), table1[SEGMENT_ID] = max ( table1[SEGMENT_ID] ) ) ) >= 2, "YES", "NO" )

[sv98917n]

The MAX made everything come back as "no" and when I made MAX, EARLIER, it gave me the original result. 

[amitchandak]

@sv98917n , try

maxx(summarize(table1,table1[SEGMENT_ID],"_1" , COUNTROWS(table1)),[_1]>= 2, "YES", "NO")

[sv98917n]

I got the first version to work. Thank you!!!