Forum Discussion
Filter Two Fact Tables
I have two fact tables that are related to a dimension table, like so: 'Campaign Clicks' *<--1 'Customers' 1 --> * 'Inbound Calls' I need to build a measure showing the average number of inboun...
MightyMicrobe , Try a measure like
Measure =
var _min = calculate(Min('Campaign Clicks'[Start DAte]), allexcept(Customers[Customers]))
return
calculate(sumx(values(Customers[Customers]) , count('Inbound Calls'[Call ID]), Filter('Inbound Calls', 'Inbound Calls'[Date] >= _min && 'Inbound Calls'[Date] <=_max)))
Sorry, this does not work. The last FILTER in the RESULT clause trips it up.