Forum Discussion
Understanding Multiple Fact Tables
Hi I would be grateful for some assitance with the following data model design query....... I have the following structure 1) Fact Table 1 Sales :(1 row per sale) : Contains details of s...
Greenwoodr v-frfei-msft I know this is old, but I have the same questions ...which approach to calculate the Sales for each "campaign" per customer
I'm not sure if this is the "best way" and may be considered bad practice.
However I normally make use of TREATAS in these cases to move the list of customers from one fact to another.
Something like:
CALCULATE(
[Your Measure],
TREATAS(
VALUES( Campaign[CustomerId] ),
Customer[CustomerId]
))
If anyone has a better suggestion would be interested.