Forum Discussion

gaiusgw's avatar
gaiusgw
Icon for Helper III rankHelper III
5 years ago
Solved

Identify matching results

Not sure how to go about this...    Sometimes I need to know when customers have ordered the same items so I can let the customers know and avoid a conflict.    I would like to be able to choose ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi gaiusgw ,

    Measure change to this:

    test = IF(CALCULATE(DISTINCTCOUNT('CUSTMAST'[CUSTNAME]),FILTER(ALLSELECTED('OPENDET'),'OPENDET'[Color]=MAX('OPENDET'[Color])&&'OPENDET'[Style]=MAX('OPENDET'[Style])))>=2,"#FF0000","#000000")

     

    before chage:

     

    after chage:

     

     

    Best Regards

    Lucien

gaiusgw's avatar
gaiusgw
Icon for Helper III rankHelper III
5 years ago

It would be nice if it only showed the conflicting style/color but this could be an option too if it could display the matches in highlights so it is clear.