Forum Discussion

crsmith3's avatar
crsmith3
Frequent Visitor
8 years ago
Solved

Same DAX Calc - diiferent answer: Import v Direct Query

Hi, I have created a market share calculation:   Market Share = DIVIDE (     SUM ( 'Sales Invoice'[Invoice Amnt (LCY)] ),     CALCULATE ( SUM ( 'Sales Invoice'[Invoice Amnt (LCY)] ), ALL ( Custo...
  • crsmith3's avatar
    crsmith3
    8 years ago

    Used ALLEXCEPT, instead of ALL which gave me the expected results.

crsmith3's avatar
crsmith3
Frequent Visitor
8 years ago

Used ALLEXCEPT, instead of ALL which gave me the expected results.