Total is not correct for data column in Power Bi matrix

[PowerBI88]

Hi,

I have a matrix where I put both measures and simple columns and the totals are not correct.

As regards measures I found a possible fix here: https://businessintelligist.com/2020/07/02/what-to-do-when-power-bi-totals-are-wrong/

Instead I don't know how to fix the situation for columns that are not measures.

Here is my dataset, the column I am talking about is "PretaxCost":

Thank you 

Kind regards

Marta

[Anonymous]

Hi @PowerBI88 ,

How did you get the [PretaxCost]? I notice that the total of [Delta] and [%Variazione] are also not the sum of there values in row level.
There might be some details that were not mentioned in your description above. And it's difficult for us to reproduce the scenario.
It's better to share some sample data so that we could figure out what is going on.

Best Regards,

Jay

[amitchandak]

@PowerBI88 , if this is a column - PretaxCost, what is aggregation used for this one, other than distinctcount, min/max grand total should match

[PowerBI88]

I think that the aggregation is sum.

For the measures I used this formula to fix the total: 

FixCommission = SUMX(Values(AzureTagsEnvironment[Value]), AzureUsageRecords[% Variazione])

Kind regards

Marta

[amitchandak]

@PowerBI88 , Grand total will be recalculated to % measure will not be sum , they will sum(A)/Sum(B) based on grand total. If you need sum, You need to do what you have done

FixCommission = SUMX(Values(AzureTagsEnvironment[Value]), AzureUsageRecords[% Variazione])

here [% Variazione] should be measure 

if this is a column then

FixCommission = SUMX(Values(AzureTagsEnvironment[Value]), calculate(average( AzureUsageRecords[% Variazione]) ))

[PowerBI88]

Sorry I don't understand. My problem is related to column PretaxCost, not to %Variazione.