Using Drillthrough values to filter a table

[cbarham]

I don't know if what I'm trying to do is possible, but I need to figure something out. I have a matrix with values from a measure, and the rows and columns are not connected to my dataset in any form. I want to be able to drillthrought to the rows for each value, but I have no way to limit the rows based off of anything on my drillthrough. Basically, I need to be able to make a table that would dynamically change based on the values being passed through. I was hoping somethign like:

SWITCH(TRUE()

,SELECTEDVALUE('Rows'[Row Name]) = "1. Marketing Qualified Leads" && SELECTEDVALUE('Columns'[Column1]) = "Trailing 12 Months",

FILTER(Data,AND(DATEDIFF(Data[MQL Date], TODAY(), MONTH) <= 12,NOT ISBLANK(Data[MQL Date])))

,SELECTEDVALUE('Rows'[Row Name]) = "1. Marketing Qualified Leads" && SELECTEDVALUE('Columns'[Column1]) = "Year to Date",

FILTER(Data,AND(YEAR(Data[MQL Date])=YEAR(TODAY()),NOT ISBLANK(Data[MQL Date]))) 

would return a table but it won't. Am I trying to do the impossible? This seems to be somewhat frustrating.

[Anonymous]

Hi @cbarham ,

Two tables with no relationship with each other? How about create a intermediate table?

Better to share some sample data to us for further analysis. Please make sure you don't have any Confidential Information before sharing.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[sturlaws]

Hi @cbarham,

sharing a sample report would make it easier to help you.

Cheers,
Sturla