Reply
Beniya_Sam_14
Frequent Visitor

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]'),"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

Yet to Proc.png

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

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.

Hi @v-rzhou-msft ,

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

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)