topic Re: Column Total Missing One Row in DAX Commands and Tips

Column Total Missing One Row

Brad_Roberts — Wed, 28 Dec 2022 22:33:16 GMT

I'm attempting to sum up Move_outs (should be -36,657, it's missing the highlight row). Column 1.Move-Out Data pulls in Change SF < 0 (this works). 1.Move-Out SF creates the total, I have these measures split out to help troubleshoot. 1.Move-Out SF = if(HASONEFILTER('Properties'[Property]),[1.Move-Out Data], SUMX(values('Properties'[Property]),[1.Move-Out Data])).

The purple highlights are my measures:

Start SF = calculate(sum('Tenancy Data'[All Area]),all(Dates),USERELATIONSHIP(Dates[Date],'Inactive Dates'[Start Date]))

Change SF = calculate(sum('Tenancy Data'[All Area])) - [Start SF ]

Thank you.

Re: Column Total Missing One Row

Greg_Deckler — Wed, 28 Dec 2022 22:45:24 GMT

Brad_Roberts 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: Column Total Missing One Row

Anonymous — Thu, 29 Dec 2022 01:56:56 GMT

Hi Brad_Roberts ,

According to your description, you mean that the measure [1.Move-Out Data] does not total correctly in the matrix, right?

Please try to create a measure [total_1.Move-Out Data].

total_1.Move-Out Data = SUMX( SUMMARIZE( 'Table', 'Table'[RowName], 'Table'[ColumnName], "total",[1.Move-Out Data] //your measure ), [total] )

You can refer to the following documents that may be helpful to you:

How to Make Measures Total Correctly in Power BI Tables - ArcherPoint

Best Regards,

Neeko Tang

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

Re: Column Total Missing One Row

Brad_Roberts — Thu, 29 Dec 2022 16:26:47 GMT

Anonymous ,

I know why 1.Move-Out Data doesn't work but I can't figure out 1.Move-out SF.

This solution was from the article you linked to that I was referencing before my post. I tried your solution but it results in the same error as above...the -4,051 is left out of total. I'm not sure why this row is different than the other rows that are included.