Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Dear Team,
I need help in adding multiple filters to the below measre :
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 🙂
No dear it's not working its reflect a blank amount.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |