topic Re: filter parameter in dax in DAX Commands and Tips

filter parameter in dax

dogburalHK82 — Wed, 31 May 2023 05:49:21 GMT

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"?

Re: filter parameter in dax

tamerj1 — Wed, 31 May 2023 06:54:50 GMT

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.

Re: filter parameter in dax

dogburalHK82 — Wed, 31 May 2023 13:40:42 GMT

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.

Re: filter parameter in dax

tamerj1 — Wed, 31 May 2023 13:58:46 GMT

dogburalHK82
Pleasr try

CALCULATE ( [OT], REMOVEFILTERS ( ) )

Re: filter parameter in dax

dogburalHK82 — Wed, 31 May 2023 22:26:27 GMT

tamerj1 that ignored all filters. When changing early or late parameter, it does not work.

Just like ALL() inside calculate.

Re: filter parameter in dax

tamerj1 — Thu, 01 Jun 2023 02:17:28 GMT

dogburalHK82

Can you share a sample file?

Re: filter parameter in dax

dogburalHK82 — Thu, 01 Jun 2023 04:10:21 GMT

tamerj1 please see if you can down

https://filebin.net/96iyutj39jjhepsw

Re: filter parameter in dax

tamerj1 — Thu, 01 Jun 2023 05:19:20 GMT

dogburalHK82

Re: filter parameter in dax

dogburalHK82 — Thu, 01 Jun 2023 05:51:12 GMT

tamerj1 Thank you