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!





     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it works.

 

new measure: =
SUMX (
    SUMMARIZE (
        your_fact_table,
        factory_dim[Factory column],
        platform_dim[Platform column],
        calendar_dim[WW column]
    ),
    [Delta LV 1 measure]
)