Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to filter except for 'Late window'.
Solved! Go to Solution.
please clarify how do you want the measure calculation to change with the parameter? Please provide more details about your report and data model.
PO No.Item NumberOrder DateDue dateReceipt dateOrder quantityReceipt Quantitydays diff
P1 | Part_1 | 1/01/2023 | 30/05/2023 | 31/05/2023 | 5 | 5 | 1 |
P2 | Part_2 | 1/02/2023 | 30/05/2023 | 29/05/2023 | 5 | 5 | -1 |
P3 | Part_3 | 1/01/2023 | 30/05/2023 | 5/05/2023 | 5 | 5 | -25 |
P4 | Part_4 | 1/01/2023 | 30/04/2023 | 30/05/2023 | 5 | 5 | 30 |
say, with above raw data, i want to calculate on time delivery of shipment.
I have set 2 parameter, called "early" and "late". With that, below measure has been generated.
@tamerj1 that ignored all filters. When changing early or late parameter, it does not work.
Just like ALL() inside calculate.
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |