Forum Discussion

dogburalHK82's avatar
dogburalHK82
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 'Late window' was created from parameter that contains only a single column from 1 to 10. 
 
I have got error like below; obviouse the parameter has a single column. In this case, what is the alternative way to filter all except "Late window"?

 

8 Replies

  • tamerj1's avatar
    tamerj1
    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's avatar
      dogburalHK82
      Helper III
      3 years ago

      tamerj1 

       

      PO No.Item NumberOrder DateDue dateReceipt dateOrder quantityReceipt Quantitydays diff

      P1Part_11/01/202330/05/202331/05/2023551
      P2Part_21/02/202330/05/202329/05/202355-1
      P3Part_31/01/202330/05/20235/05/202355-25
      P4Part_41/01/202330/04/202330/05/20235530

       

      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.