Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Create a column summary with drill-through to filtered data

Given a basic table T with N columns.

I'd like to take a subset of columns from T and transpose them to rows.

Then compute a summary value for each of these rows, and then drill-through to

filter a table on a second page...the summary table would look like this:


colname | summary


abc         |  value1

def         |  value2

ghi         |  value3


Is this possible?

I tried using the ROW function to manually build rows, but the column

names are just strings -- they don't link back to data.

I also tried using the ROW function to manually build a table, but could

not make the drill-through work from inside a ROW structure...







Super User III
Super User III

@p6sk Read this post to get your answer quickly.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.