Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |