Forum Discussion
erhan_79
Post Prodigy
6 years agoFormula Help - (Delivery Performance Calculating)
Dear All , i need your kind supports about below problem I have two tables one of them shows purchasing orders and the other one shows delivery orders which are related with purchase orders....
- 6 years ago
Hi erhan_79 ,
For your first visual, you could create a measure as a condition in the filter pane.
Measure = VAR a = SELECTEDVALUE ( Purchase[Purchase Date] ) VAR b = SELECTEDVALUE ( Delivery[Delivery Date] ) RETURN IF ( a = b, 1, 0 )For your second visual, you could create two measures to replace original columns.
_Delivery Quantity = CALCULATE ( SUM ( Delivery[Delivery Quantity] ), ALL ( Delivery[Delivery Date] ), FILTER ( Delivery, Delivery[Vendor Name] = SELECTEDVALUE ( Delivery[Vendor Name] ) ) )_Order Quantity = CALCULATE ( SUM ( Purchase[Order Quantity] ), ALL ( Delivery[Delivery Date] ), FILTER ( Delivery, Delivery[Vendor Name] = SELECTEDVALUE ( Delivery[Vendor Name] ) ) )Then show the result which is not blank in the filter pane.
Here is my test file for your reference.
v-eachen-msft
Community Support
6 years agoHi erhan_79 ,
For your first visual, you could create a measure as a condition in the filter pane.
Measure =
VAR a =
SELECTEDVALUE ( Purchase[Purchase Date] )
VAR b =
SELECTEDVALUE ( Delivery[Delivery Date] )
RETURN
IF ( a = b, 1, 0 )
For your second visual, you could create two measures to replace original columns.
_Delivery Quantity =
CALCULATE (
SUM ( Delivery[Delivery Quantity] ),
ALL ( Delivery[Delivery Date] ),
FILTER (
Delivery,
Delivery[Vendor Name] = SELECTEDVALUE ( Delivery[Vendor Name] )
)
)_Order Quantity =
CALCULATE (
SUM ( Purchase[Order Quantity] ),
ALL ( Delivery[Delivery Date] ),
FILTER (
Delivery,
Delivery[Vendor Name] = SELECTEDVALUE ( Delivery[Vendor Name] )
)
)
Then show the result which is not blank in the filter pane.
Here is my test file for your reference.