Forum Discussion

Lowe182's avatar
Lowe182
Regular Visitor
4 years ago

Total row not calculating correctly - Matrix Measure

Hello all,   I have tried other solutions to my problem but none of them worked for me. I have a matrix that projects annual expenses by pay period. For now, the "Projection" column fills in any mi...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Lowe182 

Thanks for reaching out to us.

Please try this, create the 3 measures below,

Projection Value=
IF (
    SUM ( DETAIL_FINAL[AMOUNT] ) = BLANK (),
    CALCULATE (
        SUM ( DETAIL_FINAL[AMOUNT] ),
        FILTER (
            ALLSELECTED ( A_DATETABLE[FY] ),
            A_DATETABLE[FY]
                = SELECTEDVALUE ( A_DATETABLE[FY] ) - 1
        )
    ),
    SUM ( DETAIL_FINAL[AMOUNT] )
)
Projection Total= sumx(DETAIL_FINAL,[Projection])
Projection=if(isfilterd(DETAIL_FINAL[ID]),[Projection Value],[Projection Total])

 

Best Regards,

Community Support Team _Tang

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