Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I am unable to understand why I cannot create visuals with data from my two fact tables joined through a dimension table. The schema is described below, I joined the two tables through a dimension based on the same id.
If I want to create a visual in which I pull attributes from Fact One and Fact Two, i get an error saying there is no valid relationship between the tables. I tried switching the cross filter direction to 'both' for both relationships: did not work. Tried to pull attributes from all three tables, thinking that maybe all three tables have to contribute to the visual for it to work. Same issue.
The only way I can link the two tables in the same visual is by doing a many to many relationship between the two fact tables. What am I doing wrong?
Also, I have a similar issue with products table where I am linking Fact Two to Product table (fact:many to product:one), then linking Product dimension to Product Options dimension (Product:one to Product Options:many). I cannot split the fact table sales data by Product Options. The only way to make it work is again, doing a many to many relationship between Fact Two and Product Options.
Please help!
@ChPetru , if you drag two not Summarize columns from fact1 and Fact2 you will not able able to do so.
One you have something from the Dim table in the visual. you will able to use the Not Sumamrized column from one table and aggregated from another table or aggregated from both tables
Thank you for the reply. I noticed measures will work, like you said, but if this was a SQL join through the dim_accountid it would just associate the two facts in the same table.
Why is PowerBI unable to do so unless the two tables are linked directly through many:many relationship?
Is there a way I can display the two facts in the same table visual using the relationship as in my screenshot? (through dim_account table)
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |