Need help on a Measure with multiple filter criteria

[ERing]

I have sample data below in a table titled Fact_Order_Revenue. This table is connected to my DIM_Calendar table using Fact_Order_Revenue.Date to DIM_Calendar.Date.

I am also using DIM_Calendar.Date to drive the date slicer on my dashboard.

I need a measure that calculates Total Revenue with the following criteria:
1. SUM Revenue + Revenue_Added
2. Conversion_Source = Online + Phone

3. CreatedOnDate AND CompletedOnDate are between the dates in my date slicer

I'm unsure how to incoproate this criteria into a measure so any help is much appreciated!

Date	Markting Channel	Conversion_Source	Revenue	Revenue_Added	Order_Count	Added_Orders	CreatedOnDate	CompletedOnDate
9/23/2023	Google	Online	980	3070	4	2	9/27/2023	10/2/2023
5/31/2022	Social Media	Phone	1041	4571	3	5	6/3/2022	6/4/2022
12/19/2023	Television	Online	2156	4124	5	1	12/22/2023	12/26/2023
2/6/2023	Radio	In Person	4231	4094	2	3	2/9/2023	2/12/2023
10/10/2022	Email	Online	4714	1536	3	3	10/13/2022	10/14/2022
4/5/2022	SMS	Phone	2922	2601	2	1	4/8/2022	4/9/2022
10/2/2022	Direct Mail	Online	3308	4471	3	1	10/5/2022	10/9/2022
6/8/2023	Google	Phone	691	4072	3	5	6/11/2023	6/13/2023
9/15/2022	Social Media	In Person	2152	3399	3	1	9/18/2022	9/22/2022
10/5/2021	Television	Online	4774	4868	5	2	10/8/2021	10/9/2021
5/13/2023	Radio	Online	3685	657	3	3	5/16/2023	5/21/2023
11/23/2023	Email	Phone	806	1784	5	5	11/26/2023	12/1/2023
9/4/2022	SMS	In Person	3423	4401	3	2	9/7/2022	9/10/2022
11/15/2023	Direct Mail	Phone	1058	1728	1	1	11/18/2023	11/22/2023
7/2/2023	Google	Online	4836	2519	5	4	7/5/2023	7/10/2023
10/23/2022	Social Media	Online	3769	2141	3	1	10/26/2022	10/28/2022
9/23/2021	Television	Online	3182	2279	3	2	9/26/2021	9/27/2021
11/24/2022	Radio	In Person	1211	4627	4	5	11/27/2022	11/30/2022
3/21/2023	Email	Phone	4847	4381	1	4	3/24/2023	3/26/2023

[v-bmanikante]

Hi @ERing,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[Ashish_Mathur]

Hi,

What dates will you select in the slicer and what exact number are you expecting in the result.  Highlight those rows for us to know the rows that should be considered.

[lbendlin · Accepted solution]

Total Revenue = 
var d = VALUES('Calendar'[Date])
return CALCULATE(sum(Fact_Order_Revenue[Revenue])+sum(Fact_Order_Revenue[Revenue_Added]),
          treatas({"Online","Phone"},Fact_Order_Revenue[Conversion_Source]),
          Fact_Order_Revenue[CreatedOnDate] in d,
          Fact_Order_Revenue[CompletedOnDate] in d)