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

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!!!