Forum Discussion
weird behaviour (cross join?) in very simple model - table visualization
Hi!, Im getting very weird results, I have this simple model: I have this table visual using sum of reseller sales as an implicit measure (I want to avoid it): The results are OK, bu...
JohnShepherdAPD
Helper II
Helper IIHi I think this is because you are using the Fact 1 ID in the visual that has no relationship to ID in Fact 2
if you use the ID from Fact 2 you shouldn't see this behavior
you can see this behavior is also present when you use the implicit column sum as 3000 reseller sales is actually also duplicated, assuming reseller_sales = 3000 for Bike and not 6000 as per your image.
hi, yes I know reseller_sales are 3000 for bike, and is just what I need, I want the reseller sales for each row, visually is duplicated, but at total level is Ok, I need that to be able to do other calculations at the fact1 level. The current model is just an example of the real one.