Izham Member

Comments

  • Two distinct items will be used to calculate both items A and B. It will, of course, display two distinct totals. Here is the example (in simple excel) : Year Product Quantity 2022 a 300 2022 a 300 2022 b 500 2022 c 800 2022 a 300 Total 2200 Total year 2022 : 1600 not 2200 because item "a" is repeating 3 times
    in Sum distinct Comment by Izham 8:25AM
  • in excel I'm using this DAX code : SUMX(DISTINCT('Master Data'[LR_YR_art]),CALCULATE(DISTINCT('Master Data'[Soh CDC Current QTY])))
    in Sum distinct Comment by Izham October 15
  • Yes, but it can be different items as well…😓
    in Sum distinct Comment by Izham October 15
  • I am still receiving different quantities, the correct amount shown in the Excel picture above...
    in Sum distinct Comment by Izham October 12
  • Thank you for the feedback. However, when I compare it to an excel file, I still do not get the same answer. For the record, the duplication occurs annually. Please help.
    in Sum distinct Comment by Izham October 11
Avatar