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] dat...
  • 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" )

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

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

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