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.


lbendlin's avatar
lbendlin
Super User
7 months ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523