Calculated Table

[kmes912]

Hi - working with the below model, I'm trying to make a calculated table.

Where it lists out all of units, they are completely unique in "00 Lookup Org Attribute" and present a list of the BIC-DEPT-SPROID associated. The units is 557 lines.

if I do a visual currently, table, and I use UNIT and BIC-DEPT-SPROID, I get what looks like a list of each unit and their applicable lines, I tried to export this in order to use that as a my table, but It says it is too big. Really I need to be able to have a unit list of UNIT-BIC-DEPT-SPROID as what it "should be" and the comparison is a table that shows what UNIT-BIC-DEPT-SPROID is confirmed, to be able to identify what is missing. 

I've tried generate, summarize, generate all, innerjoins, outerjoins, everything I could google but still not getting the desired results. 

Desired result is something like this, preferred as one string but want anything at this point to be able to compare what should be vs what is (what is has the unit already in the string)

[amitchandak]

@kmes912 , Based on what I got looking at the model. You should create a bridge table first of all.

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.