Forum Discussion

Icon for Helper III rank

Helper III

3 years ago

Solved

filter 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...

tamerj1
3 years ago
dogburalHK82
practice_2.pbix72 KB

Icon for Community Champion rank

Community Champion

3 years ago

Hi dogburalHK82

please clarify how do you want the measure calculation to change with the parameter? Please provide more details about your report and data model.

dogburalHK82
Helper III
3 years ago
tamerj1

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
  3 years ago
  dogburalHK82
  Pleasr try
  
  CALCULATE ( [OT], REMOVEFILTERS ( ) )
  - dogburalHK82
    Helper III
    3 years ago
    tamerj1 that ignored all filters. When changing early or late parameter, it does not work.
    Just like ALL() inside calculate.