Forum Discussion
Column Total Missing One Row
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.
3 Replies
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/n4TYhF2ARe8Hi 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.
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.
