Measure

[Ronning]

 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 1 ,4, and 7. 

Hope you guys can help me // Ronning

[amitchandak · Accepted solution]

@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

https://www.youtube.com/watch?v=7CqXdSEN2k4

[v-yinliw-msft · Accepted solution]

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.

[amitchandak · Accepted solution]

@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

https://www.youtube.com/watch?v=7CqXdSEN2k4