- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
01-20-2024 07:14 PM | |||
04-15-2024 09:31 AM | |||
02-21-2024 08:15 AM | |||
04-11-2023 02:46 PM | |||
04-14-2024 04:35 PM |
User | Count |
---|---|
21 | |
17 | |
13 | |
6 | |
5 |
User | Count |
---|---|
29 | |
28 | |
20 | |
13 | |
10 |