Forum Discussion

sandy_liew's avatar
sandy_liew
Frequent Visitor
1 year ago
Solved

Grand Total for Matrix Visual not displaying correctly

Hi, I have the DAX measure shown below for Delta LV column where it is actually obtained from the values of "Outs' -"LV", I would like to display the row subtotals as well as row grand total for the ...
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi  sandy_liew 

    Try considering the below steps:

    Create the Numeric Measure

    Delta LV Numeric = 
SUMX (
    ADDCOLUMNS (
        SUMMARIZE('Grand_Total', 'Grand_Total'[Factory], 'Grand_Total'[Platform]),
        "Delta", [Actual Outs] - CALCULATE(SUM('Grand_Total'[LV]))
    ),
    [Delta]
)



    Create the Formatted Display Measure

    Delta LV Formatted = 
VAR DeltaLV = [Delta LV Numeric]
RETURN
    IF(
        ISBLANK(DeltaLV),
        BLANK(),
        IF(
            DeltaLV < 0,
            "(" & FORMAT(ABS(DeltaLV), "#,0") & ")",
            FORMAT(DeltaLV, "#,0")
        )
    )

     

     


     

    If this response is helpful, please mark it as an Accepted Solution to benefit other community members.
     

    Thank You!





     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi sandy_liew 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.