Drill through by inactive relationship

[laganlee]

Hi

I want to drill through by an inactive date:

The red bar values are calculated using USERELATIONSHIP.

The relationship is this:

So when I want to drill through, I want the values in my drill through page to be by E Training Actual Date

I can get one value using MAX, but how do I get all the values for a drill through month?

Many thanks for looking at this.

[v-xuxinyi-msft]

Hi @laganlee 

To better help you, I need to confirm with you your question, do you need to show all the relevant E Training Actual Date dates on the drillthrough page? Are you comfortable sharing your PBIX files?

If I don't misunderstand you, you can try to see if you can get the results you want without DAX, and backup DAX before doing so.

For more information about drillthrough, you can refer to the following documents: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[laganlee]

Hi Yulia,

Many thanks for that!

I want to drill through to all rows by E Training Date.

That link is very much appreciated, but it unfortunately it does not show how to drill through by an inactive relationship.

Hope that helps with a solution 🙂