Forum Discussion
aggregated value
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
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
3 Replies
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 requirednew measure = sum(sales[sales])
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
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 RegardsMaggie
