Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BabaOleg
New Member

Totals are duplicated for all Categories?

Hi all, I'm having trouble with totals being duplicated, I have 3 tables joined, one has the Instances, one has the ID and one has the Name , how would I write a calculation to get the Total instances PER Name?

Here is what I get:

NAME | ID | INSTANCES

Greg   | 12 |  30
Kelly   | 14 |  30
Mike   | 19 |  30
John   | 23 |   30

 

Here is what I need to see:

 

NAME | ID | INSTANCES

Greg   | 12 |  10
Kelly   | 14 |  5
Mike   | 19 |  3
John   | 23 |   2

 

One of the tables is Many-Many but it needs to be as there are multiple ID rows for each Instance in both tables, do I need to calculate that first or as part of the DAX to solve the count per Name?

Let me know what other information you need.

Thanks in advance 🙂

4 REPLIES 4
v-zhangtin-msft
Community Support
Community Support

Hi, @BabaOleg 

 

Have you solved your problem yet? If it is not resolved, can you provide example graphs of the data from the 3 tables? You can show it as a screenshot or excel.

 

Best Regards,

Community Support Team _Charlotte

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

tharunkumarRTK
Super User
Super User

@BabaOleg 

can you provide the PBIX file with sample data?

I wouldn't know how to re-create the table connections and PBIX file with sample data sorry

@BabaOleg 

Ok, then share the sample data as an excel file.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.