Forum Discussion

cbarham's avatar
cbarham
Regular Visitor
6 years ago

Using Drillthrough values to filter a table

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.
Need Help

2 Replies

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    Hi cbarham,

     

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

     

    Cheers,
    Sturla

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.