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  ，

You could use the following Steps:

Step1， Use the following measure:

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

 

Step 2,configure color:

 

Final you will see the below:

 

Wish it is helpful for you!

 

Best Regards

Lucien

 

gaiusgw's avatar
gaiusgw
Helper III
5 years ago

Hey Lucien,

Thanks for the help. I feel like this is really close but for some reason I am getting a result where everything is red... Here is a full screenshot so hopefully you can see where this might have gone wrong. The customer name comes from a different table than the style and color data so maybe this is the issue?