Measure Not Showing Total

[Beniya_Sam_14]

Hi All,

I am having trouble showing total using Measure.

Table 1 = SUMMARIZE('Tablename','Tablename[ITEM_CODE],"Sale qty",MAX('Tablename'[Sales Qty]),"Sales Value",MAX('Tablename'[Sales Value]'),"Stock qty",SUM('Tablename'[STOCK_QTY]),"Stk value",SUM('Tablename'[TOTAL_STOCK]))

Measure 1 = if(SUM('Tablename'[STOCK_QTY])>=SUM('Tablename'[Sales Qty]),blank(), SUM('Tablename'[Sales Qty])-SUM('Tablename'[STOCK_QTY]))

When am trying to put that Measure in Matrix , it is not Showing Total. 

The Below Screenshot shared has no total for first two measure

[Anonymous · Accepted solution]

Hi @Beniya_Sam_14 ,

I suggest you to try code as below.

Measure 1 =
VAR _VIRTUALTABLE =
    SUMMARIZE (
        'TableName',
        'TableName'[Section],
        "Measure 1",
            IF (
                SUM ( 'Tablename'[STOCK_QTY] ) >= SUM ( 'Tablename'[Sales Qty] ),
                BLANK (),
                SUM ( 'Tablename'[Sales Qty] ) - SUM ( 'Tablename'[STOCK_QTY] )
            )
    )
RETURN
    SUMX ( _VIRTUALTABLE, [Measure 1] )

Best Regards,
Rico Zhou

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

[Beniya_Sam_14]

Hi @Anonymous ,

Thank you for your reply. That Works fine. But if I change the dimension From Section to another Dimension, it shows different value.