Forum Discussion
ERing
Post Partisan
Post PartisanNeed help on a Measure with multiple filter criteria
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.Dat...
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)
Ashish_Mathur
Super User
Super UserHi,
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.