Column Total Missing One Row

[Brad_Roberts]

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.

[Anonymous]

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. 

[Brad_Roberts]

@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.

[Greg_Deckler]

@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