Drill-through with measure with multiple userrelarionship

[Shamkosar]

Hi, I have a measure C which is a result of measure A minus measure B.

Measure A has date1 as userrelationship context

Measure B has date2 as userelationship context.

When I drill-through to the page it does not show correct rows on drill through table even when I have Measure C set to 1 on the table visual.

Can any one help?

[Kedar_Pande · Accepted solution]

@Shamkosar 

The issue arises because drill-through filters in Power BI are based on the active relationship in the model, which in your case may not align with the relationships needed for Measure A and Measure B. Since Measure A and Measure B rely on separate relationships (USERELATIONSHIP), using a single drill-through may not apply both date contexts correctly.

[Shamkosar]

Hi @Kedar_Pande thanks for your response, is there a work around this issue? I'm sure other people have come across this issue.