Problem with counts of Parts

[janisCNH]

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

[austinsense · Accepted solution]

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.

[janisCNH]

Good VersionBad Version

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