Forum Discussion

Post Partisan

6 years ago

Solved

Table Sum is not correct

Dear all, I create a table, but the total on the last line seems not correct, any idea? Thanks!

v-frfei-msft
6 years ago
Hi xiumi_hou ,

Please create a new measure like that to work on it.

SUMX(your table, [measure])

Community Champion

6 years ago

i think you use aggregation

pick column Current in Vusuals pane and set Do not summarize

Post Partisan

6 years ago

Hi az38 Thanks for reply.

I just checked my panel, and it shows not aggregation.

az38
Community Champion
6 years ago
xiumi_hou

what is Current? is it field in data source or calculated column or measure?
- xiumi_hou
  Post Partisan
  6 years ago
  az38 column one is a switch function of different measures. Current is the count value of measures. (Each row is a different measure) Thanks!
  - az38
    Community Champion
    6 years ago
    xiumi_hou
    
    the issue is somewhere in measures, give us the measure statements to troubleshooting