Forum Discussion
Problem with counts of Parts
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.
Impactful IndividualHi, 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.
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
