Forum Discussion

Natsu177's avatar
Natsu177
Frequent Visitor
1 year ago
Solved

Best Way to Build Visual Using Fields from Two Separate Fact-Dimension-Custom Chains?

Hi everyone, I need help creating a visual in Power BI that combines data from 4 tables. Fact A → many-to-one → Dim A → one-to-many → Custom table A Fact A → many-to-one → Dim B → one-to-many ...
Need Help
Tips and Tricks
  • MasonMA's avatar
    MasonMA
    1 year ago

    Hi, 

    If I'm in your situation I would create a bridge table to have detailed row-level combinations.

    Creating a bridge table is also simpler than other approaches. You just need to use below DAX in a new table function to have all combinations from both tables and build your relationship from there. 

    BridgeTable =
    SUMMARIZE(
    FactA,
    DimA[KeyColumn],
    DimB[KeyColumn]
    )

     

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523