cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
p6sk
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...

 

Thanks!

 

 

 

 

1 REPLY 1
parry2k
Super User III
Super User III

@p6sk Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






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

Announcements
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!

secondImage

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.

secondImage

Experience what’s next for Power BI

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