This seems a rather simple question, but I cannot resolve this in Power BI Desktop, though have done this with Power Pivot.
I have a table that details bugs, and has a unique Bug ID (bug_id) for each bug.
The same table has a column that details the Product to which the bug applies. (Uniquely identified by a Product ID, product_id). product_id has a relationship with another table that gives a meaningful name to the product.
I want to create a simple report that lists all Bug IDs against each Product ID (using the meaningful description). I am struggling though, because in the fields list bug_id is listed as a Sum, so I only get the sum of all Bug IDs, which is meaningless. I am missing something here. How should I approach this requirement to create this simple report?