Forum Discussion

pcowman1's avatar
pcowman1
Helper I
7 years ago

Summarize two columns different tables linked through third

I've been trying to do this through summarize and a new table but can't for the life of me figure out how to what I need.

 

I have 3 tables one is an Item List which has a unique key. the other two do not have anything unique to allow them to talk to each other so they go through Item List. 

 

All three have Item Number which is the list's key.

 

I need to summarize a column from each by the Item Number to allow for filtering by Item Number. How do you write a column to summarize by the key? can I summarize to the Item List table?

Need Help

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi pcowman1 

     

    It seems you may create a table with below formula.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.For further,please refer to

    How to Get Your Question Answered Quickly.

    Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( Table1, "List", Table1[List] ),
        SELECTCOLUMNS ( Table2, "List", Table2[Item list] ),
        SELECTCOLUMNS ( Table3, "List", Table3[Item list] )
    )
)

    Regards,

    Cherie