Grand total issue in measures

[majid154a]

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?

[mark_endicott · Accepted solution]

@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. 

[v-jianpeng-msft · Accepted solution]

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.

[mark_endicott · Accepted solution]

@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.