Need to display data from same column more than once, with one changing based on slicer selection

[AmandaCarriveau]

My data source is a single Excel table. There a column for "Total units". There is a column for "Total steps". I have a slicer based on "Total steps". I want to create a table visual that will display "Total units", total units based on slicer selection (for example, if 2 is selected, display total units only for rows where the value in column for total steps is 2), and a percentage of those two values. How do I do this?

[AmandaCarriveau]

Here is a data sample Sample.xlsx

[AmandaCarriveau]

I can't share the actual data, due to privacy concerns. But I can create a sample set that is similar and upload when I get a second.

[Arul]

@AmandaCarriveau ,

Can you share the sample data?

Thanks,

[AmandaCarriveau]

I did in my 9/27/22 message. Here it is again. Sample.xlsx