Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |