Forum Discussion

gaiusgw's avatar
gaiusgw
Helper 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

v-luwang-msft's avatar
v-luwang-msft
Community Support
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
Helper III
5 years ago

v-luwang-msft Yes! That did it. Thanks so much Lucien. 🙂