Forum Discussion

Thigs's avatar
Thigs
Helper IV
4 years ago
Solved

Selected Value Times Each Row?

Hi all I am trying to create some kind of formula that would work based on a selected value/what if parameter. My what if parameter is how many days of stock I want to have on hand - it is whole num...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Thigs 

    Try

    Inventory Units =
DIVIDE (
    SUM ( 'Order Data'[ORIG_ORDER_QTY] ),
    DISTINCTCOUNT ( 'Order Data'[Date Time] )
)
    * SELECTEDVALUE ( 'Days of Inventory'[Days of Inventory] )
Thigs's avatar
Thigs
Helper IV
4 years ago

I think this worked! Double checking it now manually to make sure, but it looks good!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Thigs ,

 

May I ask if your problem has been solved? Did tamerj1's post above help you? If any of the posts are helpful, then please consider accepting it as a solution to help other members find it faster. Many thanks!

 

Best Regards,
Community Support Team_Gao