Forum Discussion

markus_zhang's avatar
markus_zhang
Advocate 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...
  • v-chuncz-msft's avatar
    7 years ago

    markus_zhang,

     

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