Finding Top Columns Based on First Column

[JWillis]

I have data that looks like this, but with far more columns:

ID	Column 1	Column 2	Column 3
001	1	1	0
002	0	1	0
003	1	1	1

The first column is an identifier that connects to records on my other tables and the remaining columns give a binary yes or no for that column. I could show all of them, but I don't want to show all 50+ columns.
I'm trying to find a way to show the top 3 based on the current filters applied to the report. I know I can calculate the overall top 3 using powerquery, but then they won't adjust as filters are applied. Is there any way to find the top n columns without losing the identifier in the first column?

[ToddChitt]

"I'm trying to find a way to show the top 3 based on the current filters applied to the report."

Top 3 based on what criteria? Based on the Average across the row? Why and average? Why not simply the count of 1's for any one row. 

Assume the columns are INT, (NOT boolean), then you could have a Calculated Column like this:

[Number of YES] = [Column1] + [Column2] + ... + [Column50]

If you really need the average, then: ( [Column1] + [Column2] + ... + [Column50] ) / 50

Or, better: DIVIDE ( : ( [Column1] + [Column2] + ... + [Column50] ) , 50, 0 )

Once you have that, can you not simply do a TOP N Filter on the visual and use that calculated column?

Am I missing something?

[JWillis]

I want the top three columns as in the column with the highest average (average of all numbers in the column, not across the row). I need the average for each column because 1 indicates yes for that row in that category so an average will give me a percentage of records that hit for that category. I could just average the columns beforehand but if I apply filters from my other tables, it would still show the overall percentage, not the percentage for the applied filters.