Forum Discussion

Brad_Roberts's avatar
Brad_Roberts
Frequent Visitor
3 years ago

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 mea...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Brad_Roberts
Frequent Visitor
3 years ago

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.