aggregated value

[Anonymous]

when we drag any feild in value there are lots of option i.e sum,avg,count etc..

i hvae one column .i.e sales and want Agg(sales) in value tab without calculating a new measures there is not any defalut aggrigation like tableau have

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Could you show your expected results?

As tested, when adding a column, it is summarized as "sum" by default.

If you want to get a table which shows all agg options (sum,avg,count etc..) on "Value" for a table or a matrix visual, please refer to:

https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

shows

[amitchandak]

The default is sum for number. You can create a measureAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin if required

new measure = sum(sales[sales])