topic Re: Total not coming correct in matrix view in Developer

Total not coming correct in matrix view

redsailbi — Mon, 20 Mar 2023 11:33:17 GMT

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

Re: Total not coming correct in matrix view

v-jianboli-msft — Wed, 22 Mar 2023 01:30:23 GMT

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.

Re: Total not coming correct in matrix view

redsailbi — Wed, 22 Mar 2023 12:46:44 GMT

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.

Re: Total not coming correct in matrix view

Greg_Deckler — Thu, 23 Mar 2023 01:31:30 GMT

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

Re: Total not coming correct in matrix view

redsailbi — Tue, 28 Mar 2023 12:37:46 GMT

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