Forum Discussion
ChPetru
Helper I
Helper IPowerBI dataset simple relationship issue
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 throug...
amitchandak
Super User
Super UserChPetru , 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
ChPetruHelper I
Helper IThank 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)