Forum Discussion

Thigs's avatar
Thigs
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper IV
4 years ago

Between which two tables? The summary table? Right now I only have the one table and the what-if parameter, which I have not connected to anywhere. The Days of Inventory is a what-if parameter that simply contains numbers between 1-60. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Thigs 

That is strage. Must be something in the visual. But ofcaurse you select only value right?  Can you please share a screenshot 

  • Thigs's avatar
    Thigs
    Icon for Helper IV rankHelper IV
    4 years ago

    I officially got it to not be blank, but now it's all the same value -

     

     

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      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
        Icon for Helper IV rankHelper IV
        4 years ago

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