Sum by group and present single values of each group on the dashboard

[Anonymous]

Dear All,

I want to show sum of each group as a separate number on a dashboard. I have DAX function that sum values but then i can't present then as a single value. So my question is how to do it for the data below, what type of shape, chart to use, should i change DAX formula?

Best regards

[v-xicai · Accepted solution]

Hi @Anonymous ,

You don't need change the DAX formula, and you can choose table visual to display the result with "Don't summarize" setting . Then you can pin the visual to dashboard after publishing report.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you very much!