Forum Discussion

markus_zhang's avatar
markus_zhang
Icon for Advocate III rankAdvocate III
7 years ago
Solved

COUNTX() error

Hi experts,   I'm scratching my head about this trivial problem:   This doesn't work: =COUNTX(ALL(Table1[Code]), Table1[Sales Amount]) Error msg: A single value for column 'Sales Amount' in ta...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    markus_zhang,

     

    Just like SUMMARIZE Function, a single result needs to be returned for each [Code].

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

markus_zhang,

 

Just like SUMMARIZE Function, a single result needs to be returned for each [Code].