Forum Discussion
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
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.
2 Replies
- austinsense
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.
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
