Forum Discussion
Table visual containing fields aggregated by SUM do not filter properly
lacwilliams Your question and purpose is not very clear. Do you have problem in Desktop or in service? Secondly provide some screen shots to expalin your issue.
I am having trouble with the Service. I cannot provide the type of screen shots that you are asking for, but I can explain in further detail.
My specific question is as follows: How can I include fields, which are aggregated by sum, in a table visual and use the filter visual to display filtered data?
My purpose for doing this is so that I can provide individual lines of data in a table visual, and include the "Totals Row" feature, and then use filters to be able to look at specific data by certain criteria.
My issue is that when the fields included in the table are summed (as shown in the picture on this page: https://powerbi.microsoft.com/de-de/documentation/powerbi-service-change-the-aggregation-in-a-chart/#siehe-auch), the filters do not work properly. They will either not filter the data at all, or they will not unfilter the data when they are deselected. I could change the fields to "Do Not Summarize," but again, that prevents me from being able to apply the "Totals Row" feature.
Please let me know if you have any additional questions.