Forum Discussion

ERing's avatar
ERing
Icon for Post Partisan rankPost 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)

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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