Forum Discussion

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

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] )

tamerj1

Community 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