Forum Discussion
Create a report when field is only shown as a sum
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?
Sorry for the simple/stupid question.
Go to the Data View, Select the modelling Tab. Here the fourth section is properties, Select the Default Summerization drop down and choose "Do not Summerize".
2 Replies
- BhaveshPatel
Super User
Go to the Data View, Select the modelling Tab. Here the fourth section is properties, Select the Default Summerization drop down and choose "Do not Summerize".
- AnonymousNot applicable
Thank you so much for this quick reply. I knew it would be simple really.