Forum Discussion

Beniya_Sam_14's avatar
Beniya_Sam_14
Frequent Visitor
3 years ago
Solved

Measure Not Showing Total

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]'),"S...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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.