Forum Discussion
using multiple slicers for multiple visuals
bikerboy28 , You join to have a problem. Make them a single direction and try.
If possible try to avoid one of the two joins top to price or sales to price
amitchandak i've tried single joins but it doesn't work.
Hello
the idea of the data model is to try to make what you want to measure (fact table or fact table) surrounded by the attributes of the objects that have the measure (dimension table) and in or possible the dimension table only by pointing in direction to the fact table.
In your model it has address on both sides, and from what you review the PBI does not let you use only one address. This is generally because there is no single union (a fact table field equal to the dimension table).
I give you an example, here I have 2 tables, that to relate them you must not only use the sku or the center, but both concatenated, otherwise the combinations are multiplied
After concatenation I perform the union by this new field. and I can already get an address in the relationship, because the union field has no repeat rows. If you joined it only by sku (assuming that the sku 1 exists in center A and B) then it could not be related from 1 to 1, but from * to * (many to a lot) because row values are repeated by the union field.
Seeing your model may be the problem, whether you don't have unique values for the union field so the relationship from many to many is the only viable one.
You tell me and we check.
Best regards.
