Expanding table (Group by) without influence the other tables

[Anonymous]

Hello, I have 5 Columns (ClasssNumber, Classtart, PersonInClass,Name and Person Number) and there are more Names and PersonNumbers then ClassNumbers and Classtarts(there can be multipl lessons I already merged them), but the problem is that Name and PersonNumber are in an other Table. So when I want to expand the Table, because i need the name, the ClassNumber (Sum from all ClassNumbers ) is wrong, because there are more Names then ClassNumbers.

Can someone help me, if you need more info pls tell me

(KursNr. = ClassNumbers, Kursstart = Classstarts, PersonenInKurs = PersonInClaass)

In the Tabel:

[v-yohua-msft · Accepted solution]

Hi, @Anonymous 

Based on your information, I create sample tables:

Marge two tables:

Although there are more names than PersonNumbers, there are actually only three types of PersonNumbers. If you want to calculate the sum of PersonNumbers, you can create a measure in Power BI Desktop to do so

If you want to know more about merging tables, you can refer to the following link:

8 Ways to Combine Tables in Power BI - Power Tech Tips

How to Combine Tables in Power BI - Zebra BI

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you very much