Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 def...
Need Help
Show and Tell
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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