Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@PowerBI88 , if this is a column - PretaxCost, what is aggregation used for this one, other than distinctcount, min/max grand total should match
I think that the aggregation is sum.
For the measures I used this formula to fix the total:
Kind regards
Marta
@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]) ))
Sorry I don't understand. My problem is related to column PretaxCost, not to %Variazione.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |