Forum Discussion
Ronning
3 years agoFrequent Visitor
Measure
Hi i have problem to crate a measure that sums up the values from the Startquantity column for each MoNmber but only for the smallest OperationNumber. So i only want the Startquantity to sum up row...
- 3 years ago
Ronning , You have to add index column or nested index column in power query and then filter that
Index Column: https://youtu.be/NS4esnCDqVw
Nested index
- 3 years ago
Hi Ronning ,
You can try this method:
New a measure:
SumMin = VAR _table = SUMMARIZE ( 'Table', 'Table'[MONumber], 'Table'[StartQuantity], "MINON", CALCULATE ( MIN ( 'Table'[OperationNumber] ), FILTER ( 'Table', 'Table'[MONumber] ) ) ) RETURN SUMX ( _table, [StartQuantity] )The result is:
Hope this helps you. Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yinliw-msft
3 years agoCommunity Support
Hi Ronning ,
You can try this method:
New a measure:
SumMin =
VAR _table =
SUMMARIZE (
'Table',
'Table'[MONumber],
'Table'[StartQuantity],
"MINON",
CALCULATE (
MIN ( 'Table'[OperationNumber] ),
FILTER ( 'Table', 'Table'[MONumber] )
)
)
RETURN
SUMX ( _table, [StartQuantity] )
The result is:
Hope this helps you. Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.