Forum Discussion

ERing's avatar
ERing
Post Partisan
1 year ago
Solved

Need 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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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)

     

lbendlin's avatar
lbendlin
Super User
1 year ago

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)