Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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 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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |