Forum Discussion

Ronning's avatar
Ronning
Frequent Visitor
3 years ago
Solved

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

Hope you guys can help me // Ronning

Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    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.

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    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.