Forum Discussion
Measure creates cartesian
Hi, I have two fact tables in my model. They are both joined in the model. in FactTable1, I have a count and several YTD measures. When I drag in keys from Factable1 and FactTable2, all looks goo...
Stachu
Community Champion
Community ChampionHi, can you add sample tables from your model with anonymised data?
As described here:
How to Get Your Question Answered Quickly
From the what you have written my guess is you have multiple key columns (which ideally would all be joined), but only one of them has active relationship, which results in the multiplied numbers. You can workaround it with TREATAS, have a look here:
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/