Formula Help - (Delivery Performance Calculating)

[erhan_79]

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.

I would like to calculate delivery performance for each purchase order's first scheduled delivery time based on months .And at the same time i would like to calculate all delivery performance for each purchase order.

İ created a pbix file and did somethings but i could not catch what i find and i could not solve the problem.Could you create for me the formulas and tables .Or how can you help me ?

 i am attaching here as below screenshot infact what i want to see on power bi screen with my comments.

Also for to be more easy to solve the problem  i am sharing with you  the pbix file 's link and the source excel file's links  under screen shot.You will see the difference between my request and the created pbix file when you open my pbix file .thanks in advance 

yau can see at below which visual tables i would to see on power bi.

 The file link : 

https://drive.google.com/drive/folders/13DsWGv_eeTAMtUUF9Hqs8lV2zDXzZYIb?usp=sharing

[v-eachen-msft · Accepted solution]

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]

@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 ?