Forum Discussion

JoeH's avatar
JoeH
Frequent Visitor
4 years ago

Pass a data field without filtering on it?

I have two pages in my Power BI report - the first has a visualization to select a device from a list.  The second page contains a visualization that needs to show the application inventory for the device ID that is passed via drill through.  The ID field in the Device table (in a SQL database) is the primary key for that table.  In the Application table, the DeviceKey field has a relationship to the ID field in the Device table.

When a user selects a device from the device list visualization, I want it to get and pass the value of the ID field to the application visualization, but I don't want it to be a filter in the device list visualization.  In the application visualization, I need to take that ID and find the matching DeviceKey rows in the Application database, and display those in the appication visualization.

 

I'm having issues with:

1) Getting the value of ID in the device visualization without using it being used as a filter or displaying to the user.

2) Once the ID is passed to the application visualzation, finding all rows where DeviceKey equals ID and displaying them.

 

For #2, I've tried all kinds of DAX queries but can't figure out the proper one, if it even should be done with DAX.

 

1 Reply

  • Drillthrough is what it is.  You can use measures to "Filter Up" from the value you received  (by looking up the parent)