Forum Discussion
dogburalHK82
Helper III
Helper IIIfilter parameter in dax
Hi, I am trying to filter except for 'Late window'. OTD_PO_Total_Line(OTIF)% ALL = calculate([OTD_PO_Total_Line (OTIF) %], allexcept('Late Window','Late Window'[Late Window])) This 'L...
dogburalHK82Helper III
Helper III
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.
OT =
var _early = calculate(countA(Table1[Item Number]), filter(Table1, (Table1[days diff])<(-early[early Value])))
var _late = calculate(countA(Table1[Item Number]), filter(Table1, (Table1[days diff])>(late[late Value])))
var _OT = calculate(countA(Table1[Item Number]), filter(Table1, (Table1[days diff])>=(-early[early Value])&&(Table1[days diff])<=(late[late Value])))
var _sum = distinctcount(Table1[PO No.])
Return divide(_OT, _Sum,0)
Now I want to ignore all filters except for "late" and "early" parameter.
I would like to how to set a measure.
tamerj1
Community Champion
Community ChampiondogburalHK82
Pleasr try
CALCULATE ( [OT], REMOVEFILTERS ( ) )
- dogburalHK82
tamerj1 that ignored all filters. When changing early or late parameter, it does not work.
Just like ALL() inside calculate.
- tamerj1
Can you share a sample file?
- dogburalHK82
tamerj1 please see if you can down