cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Problem with counts of Parts

Hello Community!

I have a problem by creating a report. The report should show how many types of one part is send to a dealer. Therefor, I have two tables. One table with the data in it and one table with the assignment.

What I do is to merge the queries to see which number stands for which part. Then I create for each type one new column with an if-function that gives the reply "1" or "0" and in the next column I multiply them with the oreded quantity.

I am relativ new in Power BI, Excel etc. but I think that their should be an easier way.

It would be really nice if somebody may give me some feedback!

Regards,

Janis

1 ACCEPTED SOLUTION
Impactful Individual

Hi, great question. You're right - there's a much simpler way to accomplish this.

1. You don't have to merge the queries - you can keep the queries separate and create a relationship between the two tables.

2. Then you can write a measure that counts the number of parts, something like this ...

```// If you want to count the quantity of parts that have been sold
PartsSold = SUM(Table[Quantity])```

3. On your report you can use the type name from your assignment table and your new measure - that should sum up the quantity of products sold for each type.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂
2 REPLIES 2
Impactful Individual

Hi, great question. You're right - there's a much simpler way to accomplish this.

1. You don't have to merge the queries - you can keep the queries separate and create a relationship between the two tables.

2. Then you can write a measure that counts the number of parts, something like this ...

```// If you want to count the quantity of parts that have been sold
PartsSold = SUM(Table[Quantity])```

3. On your report you can use the type name from your assignment table and your new measure - that should sum up the quantity of products sold for each type.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂
Frequent Visitor

Thank you for the quick answer! But now I have another problem. In the first picture, you see how it should look like! But unfortunately I got the one below this morning as I wanted to work with your tip.

Or are their any obvious mistakes? Do you know a solution?

Regards, Janis

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.