Filter table visual based on values in a column

[dlogan]

This seems like it should be simple, but I have no idea how to do it. This report has a single table. One of the fields in the table is named Tests. All values in the field are 1. For the table visual shown below, the Tests column is simply a SUM of the values in that field. In other words, it's a count. How can I do something like what I have shown above the visual? I want the user to be able to limit what is shown by entering a Minimum for Tests. Thanks for any suggestions.

[lbendlin]

Your Tests slicer/parameter needs to be fed by a disconnected table, and then you use measures to get to the columns on the right.

[dlogan]

Thank you for the reply. I should have said I am very new with Power BI. A couple of months at most. I understand when you say the parameter needs to be fed by a disconnected table. I think I can do that. I have no idea how to create a measure that would then limit what shows up in the table. Can you help get me started down that path? 

[lbendlin]

yes.  The easiest way for me to help you is if you provide sample data that covers your scenario.  Ideally in a usable form (not as a screenshot)

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[dlogan]

It would be fantastic if you could help. If I get this piece figured out, it will be a huge help on a much larger project. Thank you so much.

The link below is to a copy of the file. I have created the disconnected table with a slicer. I want the user to be able to select a value from the slicer that would filter the table visual. Please let me know if you have other questions.

https://www.dropbox.com/scl/fi/n2vk19rwmkyq9kt4v92g5/Top-Performer.pbix?rlkey=08qtnautmed8m9pwuky3bi...

[lbendlin · Accepted solution]

see if this helps

[dlogan]

This is EXACTLY what I need. Thank you so much for taking the time to help. This will go a really long way to helping me understand what to do in these situations.