Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Formula 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....
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    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's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
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.

 

  • erhan_79's avatar
    erhan_79
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    v-eachen-msft  thank you very much for your help , it helped me too much .Also i need one more thing too

     

     

    i would like to show first scheduled delivery  performance with with gauge visual (as in below picture's performance ) , but when i select performance gauge is showing all month's performance , i just want to show only first scheduled month's performance , how can i show it ?