how to use multiple filter in "Sumx calculate value" Dax

NawilatiMahmoud — Thu, 05 Jan 2023 11:29:46 GMT

Dear Team,

I need help in adding multiple filters to the below measre :

Out Standing =

SUMX(VALUES('Date'[Date]),

CALCULATE(SUMX(FILTER('Claims', Claims[TRANS_DATE] <= MAX('Date'[Date]) && 'Claims'[TRANS_DATE - End Date]>= MIN('Date'[Date])),DIVIDE('Claims'[NET_TRANS_AMT_LC],DATEDIFF('Claims'[TRANS_DATE], 'Claims'[TRANS_DATE - End Date], DAY)+1)))) = This Dax is for dividing the "NET_TRANS_AMT" per day based on slider date

i need the other filletrs as below:

01- by CLAIM_TRANS_TYPE = "Text = Resreve"

02 - and only values that start date is within the 'Date'[Date} slider perioed, thats mean if the slider starting from 01-03-2022 it will ignore all records before that date and only calculate the recordes within the slider period

Data As Below Example:

GPD_PLC_ID	CLAIM_TRANS_TYPE	TRANS_DATE	NET_TRANS_AMT_LC	TRANS_DATE - End Date
1891292	Payment	12/02/2021 13:01:00	55	12/12/2021 13:01:00
1891292	Reserve	12/02/2021 12:35:01	661	12/12/2021 12:35:01
1891292	Reserve	12/14/2021 12:14:49	91	12/24/2021 12:14:49
1886030	Reserve	12/16/2021 15:05:19	1,495	12/26/2021 15:05:19
1891292	Reserve	12/01/2021 10:02:00	-19,773	12/11/2021 10:02:00
1870455	Reserve	02/13/2022 13:00:34	5,000	02/23/2022 13:00:34
1891292	Reserve	12/01/2021 15:25:01	8,446	12/11/2021 15:25:01
1891292	Payment	12/02/2021 15:37:00	1,487	12/12/2021 15:37:00
1880577	Reserve	12/16/2021 15:53:10	5,000	12/26/2021 15:53:10
1891292	Reserve	12/02/2021 09:14:00	-1,453	12/12/2021 09:14:00
1891292	Reserve	12/02/2021 13:01:00	-47	12/12/2021 13:01:00
1891292	Reserve	12/21/2021 11:01:00	-295	12/31/2021 11:01:00
1891296	Reserve	12/02/2021 16:46:02	400	12/12/2021 16:46:02
1891292	Reserve	12/02/2021 15:57:00	-58	12/12/2021 15:57:00
1891292	Reserve	01/24/2022 17:21:05	-12,969	02/03/2022 17:21:05
1891292	Reserve	01/24/2022 17:26:34	250	02/03/2022 17:26:34
1891292	Reserve	01/24/2022 17:31:05	1,295	02/03/2022 17:31:05
1891292	Reserve	12/21/2021 10:50:00	-175	12/31/2021 10:50:00
1891292	Reserve	12/14/2021 09:59:42	718	12/24/2021 09:59:42
1891292	Payment	01/25/2022 11:54:00	856	02/04/2022 11:54:00
1891296	Reserve	12/21/2021 12:02:00	4,500	12/31/2021 12:02:00
1891296	Reserve	12/21/2021 12:17:30	3,728	12/31/2021 12:17:30
1891292	Payment	12/02/2021 12:00:00	301	12/12/2021 12:00:00
1891292	Reserve	12/02/2021 12:57:13	47	12/12/2021 12:57:13
1891292	Reserve	12/01/2021 13:38:11	10,885	12/11/2021 13:38:11

Thanks in Advance 🙂

Re: how to use multiple filter in "Sumx calculate value" Dax

Anonymous — Fri, 06 Jan 2023 07:13:29 GMT

Hi NawilatiMahmoud ,

I think you can create a new measure based on [Out Standing] measure.

New Out Standing = VAR _SLIDER_DATE = SELECTEDVALUE ( 'Date'[Date] ) RETURN CALCULATE ( [Out Standing], FILTER ( ALL ( Claim ), AND ( Claim[CLAIM_TRANS_TYPE] = "Resreve", Claim[TRANS_DATE] >= _SLIDER_DATE ) ) )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: how to use multiple filter in "Sumx calculate value" Dax

NawilatiMahmoud — Fri, 06 Jan 2023 14:01:40 GMT

No dear it's not working its reflect a blank amount.

topic Re: how to use multiple filter in "Sumx calculate value" Dax in DAX Commands and Tips

how to use multiple filter in "Sumx calculate value" Dax

Re: how to use multiple filter in "Sumx calculate value" Dax

Re: how to use multiple filter in "Sumx calculate value" Dax