Forum Discussion

KS7's avatar
KS7
Regular Visitor
7 months ago
Solved

Power BI Drill-through Issue with Complex Data Model and DAX – Role-based Status Not Matching

Hi Community, I am currently working on a Power BI project with a highly complex data model involving multiple tables and multiple relationships. The dataset represents a recruitment workflow with ...
Need Help
  • v-sshirivolu's avatar
    v-sshirivolu
    7 months ago

    Hi KS7 ,
    Thanks for reaching out to Community Forum.

    I was able to reproduce this issue. The drill through itself works correctly, but when stage values are derived using DAX measures, the Application ID context can be lost if it isn't explicitly enforced.

    The reliable fix was to keep the existing model, use a small disconnected Roles table for the row layout, and update the measures to explicitly anchor on the drilled Application ID using SELECTEDVALUE with KEEPFILTERS. This ensures each role's stage value is evaluated only for the selected application and avoids any cross application leakage.

    After configuring the drill through page properly (separate source page, page type set to Drillthrough, Application ID used as the drill through field, and Used as category), the role wise stage values returned accurately for all cases, including partially completed workflows.

    Please find the attached .pbix file for your reference.

    Thank you.


v-sshirivolu's avatar
v-sshirivolu
Community Support
7 months ago

Hi KS7 ,
Thanks for reaching out to Community Forum.

I was able to reproduce this issue. The drill through itself works correctly, but when stage values are derived using DAX measures, the Application ID context can be lost if it isn't explicitly enforced.

The reliable fix was to keep the existing model, use a small disconnected Roles table for the row layout, and update the measures to explicitly anchor on the drilled Application ID using SELECTEDVALUE with KEEPFILTERS. This ensures each role's stage value is evaluated only for the selected application and avoids any cross application leakage.

After configuring the drill through page properly (separate source page, page type set to Drillthrough, Application ID used as the drill through field, and Used as category), the role wise stage values returned accurately for all cases, including partially completed workflows.

Please find the attached .pbix file for your reference.

Thank you.


v-sshirivolu's avatar
v-sshirivolu
Community Support
7 months ago

Hi KS7 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    7 months ago

    Hi KS7 ,
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions