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

v-luwang-msft Hey Lucien, I started a new pbix from scratch with dumby data to see if I could replicate the issue. The issue seems to be that your formula somehow is not taking the slicer into consideration. See screenshot below where I only have 2 accounts selected but formatting changes because other unselected accounts have the style on order. Hopefully this makes sense. I have put an arrow next to the ones that should not have been formatted. When applied to my original pbix, I end up with all red formatting because there are other customers that have the styles/colors on order that are not selected. Hope this makes it clear. Here is a link to download the pbix and source files. https://we.tl/t-BQkM2094uM. Thanks again for looking into this.