Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Good morning
I have two data sets that i am trying to link and seems like i cannot link as i have many to many relationships.
Trying to acheive if Cluster and or owner filtered,
return sum of Total based on owner
Some "names" have many cost centres so it needs to be filtered to the team leader based on the clients # and cost centre 🙂
| Name | Cluster | Owner | Location | Property | Manager | # | Cost Centre |
| Bart Simpson | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 123456 | MIR |
| Bart Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 123456 | BEA |
| Bart Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 123456 | IND |
| Lisa Simpson | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 789123 | MIR |
| Lisa Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 789123 | BEA |
| Lisa Simpson | Brisbane | Bob Smith | 1 | DEF | Katie Holmes | 789123 | IND |
| Bugs Bunny | Brisbane | Bob Smith | 1 | GHI | Tom Cruise | 987654 | MOO |
| Elmer Fudd | Brisbane | Bob Smith | 1 | ABC | Alec Baldwin | 654789 | MIR |
| Elmer Fudd | Sydney | John Harvey | 1 | JKL | Nicole Kidman | 654789 | RIT |
| Elmer Fudd | Sydney | John Harvey | 1 | MNO | Jane Fonda | 654789 | WYN |
| Name | # | Product code | Cost centre | Total |
| Bart Simpson | 123456 | 01_017_0107_1_1 | BEA | $ 40,515.28 |
| Bart Simpson | 123456 | 04_104_0125_6_1_T | IND | $ 26,640.64 |
| Bart Simpson | 123456 | 04_170_0136_6_1_T | MIR | $ 17,250.00 |
| Bart Simpson | 123456 | 04_105_0125_6_1_T | IND | $ 9,374.56 |
| Bart Simpson | 123456 | 04_102_0125_6_1_T | IND | $ 854.10 |
| Bugs Bunny | 987654 | 04_104_0125_6_1_T | MOO | $ 96,060.00 |
| Bugs Bunny | 987654 | 01_801_0115_1_1 | MOO | $ 28,125.71 |
| Bugs Bunny | 987654 | 01_802_0115_1_1 | MOO | $ 62,335.00 |
| Bugs Bunny | 987654 | 01_804_0115_1_1 | MOO | $ 33,218.80 |
| Bugs Bunny | 987654 | 01_805_0115_1_1 | MOO | $ 42,837.86 |
| Bugs Bunny | 987654 | 01_806_0115_1_1 | MOO | $ 13,654.16 |
| Bugs Bunny | 987654 | 01_832_0115_1_1 | MOO | $ 31,354.34 |
| Bugs Bunny | 987654 | 01_819_0115_1_1 | MOO | $ 7,628.00 |
| Elmer Fudd | 654789 | 04_104_0125_6_1_T | RIT | $ 23,310.56 |
| Elmer Fudd | 654789 | 04_170_0136_6_1_T | WYN | $ 16,560.00 |
| Elmer Fudd | 654789 | 01_801_0115_1_1 | RIT | $ 15,194.35 |
| Elmer Fudd | 654789 | 01_802_0115_1_1 | RIT | $ 62,335.00 |
| Elmer Fudd | 654789 | 01_804_0115_1_1 | RIT | $ 34,128.90 |
| Elmer Fudd | 654789 | 01_805_0115_1_1 | RIT | $ 44,011.50 |
| Elmer Fudd | 654789 | 01_806_0115_1_1 | RIT | $ 7,473.86 |
| Elmer Fudd | 654789 | 01_832_0115_1_1 | RIT | $ 23,856.56 |
| Elmer Fudd | 654789 | 04_170_0136_6_1_T | MIR | $ 16,560.00 |
| Elmer Fudd | 654789 | 06_431_0131_2_2 | RIT | $ 5,800.74 |
| Elmer Fudd | 654789 | 04_122_0136_6_1_T | MIR | $ 240.25 |
| Elmer Fudd | 654789 | 04_121_0136_6_1_T | MIR | $ 186.30 |
| Elmer Fudd | 654789 | 01_819_0115_1_1 | RIT | $ 9,696.00 |
| Elmer Fudd | 654789 | 04_112_0136_6_1_T | RIT | $ 403.84 |
| Lisa Simpson | 789123 | 04_104_0125_6_1 | IND | $ 51,725.44 |
| Lisa Simpson | 789123 | 01_011_0107_1_1 | IND | $ 38,794.08 |
| Lisa Simpson | 789123 | 01_013_0107_1_1 | IND | $ 54,606.24 |
| Lisa Simpson | 789123 | 04_170_0136_6_1 | MIR | $ 16,788.00 |
| Lisa Simpson | 789123 | 04_111_0136_6_1_T | IND | $ 1,075.80 |
| Lisa Simpson | 789123 | 01_026_0115_1_1 | BEA | $ 39,880.56 |
| Lisa Simpson | 789123 | 04_113_0136_6_1_T | IND | $ 455.63 |
| Lisa Simpson | 789123 | 04_103_0125_6_1_T | IND | $ 423.36 |
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 50 | |
| 44 | |
| 42 | |
| 19 | |
| 19 |
| User | Count |
|---|---|
| 70 | |
| 68 | |
| 33 | |
| 32 | |
| 32 |