Forum Discussion

sv98917n's avatar
sv98917n
Icon for Helper I rankHelper I
6 years ago
Solved

Show Duplicates With Respect To Page Slicer

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's avatar
    amitchandak
    6 years ago

    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" )

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      sv98917n
      Icon for Helper I rankHelper I
      6 years ago

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

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        sv98917n , try

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