Forum Discussion

hnguyen76's avatar
hnguyen76
Resolver II
6 years ago
Solved

DAX LeftouterJoin No Relationship

Hi All. I'm attempting to create an attribute table from two fact tables in DAX. I'm fully aware that this is far easier and better to do in PowerQuery except that I'm using a database that has slow...
Need Help
  • hnguyen76's avatar
    hnguyen76
    6 years ago

    v-juanli-msft ,
    Thanks for the reply. Unfortunately I was looking for a route that did not consider using any relationships (active or inactive) while actively avoiding M-2-M. Considering performance vs data model size I opted with my original solution to use PowerQuery 

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi hnguyen76 

two ways to get expected result as you provided:

1. create relationships

2. create inactive relationships(inactive relationships won't filter tables)

Create calcualted columns

amount2 = CALCULATE(SUM(Table2[Amount]),USERELATIONSHIP(Table1[ID.Key],Table2[ID.Key]))

customer = LOOKUPVALUE(Table2[Customer],Table2[ID.Key],Table1[ID.Key])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • hnguyen76's avatar
    hnguyen76
    Resolver II
    6 years ago

    v-juanli-msft ,
    Thanks for the reply. Unfortunately I was looking for a route that did not consider using any relationships (active or inactive) while actively avoiding M-2-M. Considering performance vs data model size I opted with my original solution to use PowerQuery