Forum Discussion

timmyvl23's avatar
timmyvl23
Regular Visitor
3 years ago
Solved

Inventory Quantity Based On Another Column Value

Hi All,   I have a data set, what I'm trying to do is based on the count of the value in the 'Shipment Reference' column, divide 'Inventory Quantity' by the count of 'Shipment Reference' . For inst...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi timmyvl23 ,

    Please create another measure based on Inventory Quantity 3 .

    measure =
VAR _b =
    SUMMARIZE (
        'Item Freight Data',
        'Item Freight Data'[shipment reference],
        "aaa", [inventory Quantity 3]
    )
RETURN
    IF (
        HASONEVALUE ( 'Item Freight Data'[shipment reference] ),
        [inventory Quantity 3],
        SUMX ( _b, [aaa] )
    )

     

    If it still does not help, please provide more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

DataInsights's avatar
DataInsights
Super User
3 years ago

timmyvl23,

 

Try this measure:

 

Inventory Quantity 3 Total =
SUMX (
    VALUES ( 'Shipment Leg Cost Headers'[Shipment Reference] ),
    [Inventory Quantity 3]
)