topic Re: Grand total issue in measures in DAX Commands and Tips

Grand total issue in measures

majid154a — Tue, 28 May 2024 10:46:31 GMT

Dear Experts,

Before, we could choose the summarization method (sum, average, grand total %, etc.) in (Measures), but in the new update, it is not allowed as shown in the example below. How can I solve this problem?

Re: Grand total issue in measures

mark_endicott — Tue, 28 May 2024 10:51:07 GMT

majid154a - The calculator icon next to your "Amouont" seletion indicates you are using a measure. This is a DAX calculation where you choose the summarization as part of the calculation.

If you use the "Amount" column, that has the Σ icon next to it, you will be able to choose the summarization as you expect.

If this works, please mark it as the solution.

Re: Grand total issue in measures

Anonymous — Wed, 29 May 2024 05:15:15 GMT

Your solution is great mark_endicott

Hi, majid154a

First of all, in the measure, if you need sum, average, grand total %, %, etc, you can use the corresponding aggregate function.

What you're currently mentioning is the aggregation capabilities that Power BI provides when columns are placed in a chart. As shown in the figure below:

By default, the metric is already an aggregate state, so it won't output sum, average, grand total %, %, etc. As shown in the figure below:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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