Undo automated measure "SUM" in a live connection

[Anonymous]

I get data from a Live connection (and I cant change something on databaseside) and I would like to turn off the automatical sum of the data.

[v-shex-msft]

HI @Anonymous,

Unfortablely, currently you can't do custom to disable these aggregation on the measurement fields in live connection mode.

For your requirements, I'd like to suggest you change the connection mode to use more edit features or try to edit the field properties on your database side.

Regards,

Xiaoxin Sheng

[SpartaBI]

@Anonymous you can switch to direct query and than you will have a local dataset looking live at the primary one. You could then change this attribute.