Forum Discussion
Summarize table based on slicer selections
I am very new to Power BI. Only a couple of months in at this point. This is my very first post to this forum. So, please forgive me if my post isn't structured in the best way.
I am pasting 2 images of my visualization page. One with the filter pane open and one with it closed. The red box is not currently part of the model but is what I need help with. Once it's working, I will move it to the filter pane. I am also pasting a link to the rows from the table for the selections showing on the visualization page. This model has only one table. That table has about 800k rows.
My goal is to give the user the ability to limit what shows up in the chart, table, and slicers in the filter pane. In the example shown below, if the red box were working, the chart would have only 2 dots and table would only have 2 rows. The 2 rows having a Location Count of 19 would not be included in the visuals nor would they be available for selection in the slicer labeled as Comparison Product.
My experience with databases is Microsoft Access. Don't laugh. I know a lot of people don't like that product, but that's what I learned and all I know. This project feels like I need to be able to create a summary query on the selected data. From there I would use a parameter (the red box) to limit the data being shown. Then, said query would be what is shown in the chart, table and slicers. I just don't know how to summarize data in Power BI based on selections made in slicers.
I sure hope this makes some sense and would greatly appreciate any help.
2 Replies
Oops. Forgot to mention where Location Count comes from. It's a simple count of rows. So, in the example shown. The table shows Location Count being 19 and 60 for 2 rows each. The sample data has that many rows total. (19 + 60) * 2. In other words, each row of data represents a single location count.
