cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

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

2 REPLIES 2
Frequent Visitor

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

Community Support

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.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors