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.
