Total is not coming correct in the matrix visual at Parent Level

Power BI
1

The Total is not coming correct. All the columns are coming from different tables. A quick help is needed here if you see the screenshot below the expected output total is 2 but I am getting 4. Attaching pbi file as well for the solution
Calculation issue.pbix (255.3 KB)

image

Here is my measure which I wrote:
Weighted Velocity =

VAR TotalActualValueTasks = SUM(‘Tasks’[ActualsValueSum])

VAR TotalActualValuePrimaryWorkItems = CALCULATE( SUM(PrimaryWorkItems[ActualValue]) )-- this portion needs adjustment DIVIDE(TotalActualValueTasks, TotalActualValuePrimaryWorkItems) * TotalStoryPointsPrimaryWorkItems

VAR TotalStoryPointsPrimaryWorkItems = SUM(Tasks[ParentEstimate])

RETURN

DIVIDE(TotalActualValueTasks, TotalActualValuePrimaryWorkItems) * TotalStoryPointsPrimaryWorkItems

2

Good afternoon @AlexBehrmann

Welcome to the forum.
It is a known problem that measures not always total correctly.
Greg Philps has written an extensive post about how to fix the problem Fix Incorrect Totals

Solution included in attached PBIX
Calculation issue WeightedVelocity v2.pbix (262.4 KB)

The weighted Velocity is calculated correctly in the table Tasks, but is not forced to calculate for the totals, this can be fixed by adding a sumx measure, in this case

Weighted Velocity CorrTot = SUMX( Tasks, [Weighted Velocity])

which forces the calculation also to calculate the measure for the totals.

image
image965×208 12.6 KB

P.S:

  1. adding the Sumx to the Velocity measure itself does not give the desired result
  2. using PWI Actual Value2 = CALCULATE(SUM(Tasks[Task ActualsValueSum])) instead of PWI ActualValue = Tasks[ActualValue] has the advantage that it gives the total of the column.

Hope this helps you further,
Kind regards, Delta Select

1 Like
3

Hello @AlexBehrmann

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

Hi @AlexBehrmann

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

5

Thank you so much that worked. Appreciate you help.