Total not coming correct in matrix view

[redsailbi]

The Total is not coming correct. All the columns are coming from different tables. A quick help is needed here.
 Here is my measure.

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

[Greg_Deckler]

@redsailbi First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[redsailbi]

@Greg_Deckler i tried to use your approach but still the total is coming incorrect.

[redsailbi]

@v-jianboli-msft if you can see the above image i.e matrix visual where the lowest tickets numbers are are showing 1.85 & 0.15. if we addd 1.85+0.15= 2(expected output) at all the levels in the visual here are the levels TeamName-->OwnerName-->WINumber-->TicketNumber.
This is how model looks like.

[v-jianboli-msft]

Hi @redsailbi ,

What does your raw data look like? Could you please provide the information about your matrix visual?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.