Forum Discussion

EricaK's avatar
EricaK
Icon for Helper I rankHelper I
1 year ago
Solved

Drillthrough also add as filter?

Hi there all! 

 

I'm working on a visualisation page with linediagrams. That page is a drillthrough from another page. 

On the overall page I select a name and use drillthrough.

On the drillthrough page I see the name pop up on the linediagrams, but also other names. I do know where that is coming from, because I use 2 different tables with names for the different pages. 

 

Question: can I make some kind of measure that looks like 

Filter = selectedvalue(table[name]) 

and post this in the filter of the visual, so only the right name pops up?

 

Extra explanation:

For this example I have three tables:

- table Saleslines with all individual saleslines. In this table are sales persons and sales responsible (there are multiple sales done where there is one sales responsible person (calculated column) but every sale individually can be done by the same person but also different persons)

- table employees for sales per person

- table employees for sales per responsible person (this is a literal copy table from the first)

 

In the main page I use the "table employees for sales per person". But when I drillthrough I only want to see the "sales per responsible person". 

The names are Identical as it is a copy. 


Looking forward to responses! Thanks in advance

  • Create a sales person dimension table, e.g.

    Sales Person =
    DISTINCT (
        UNION (
            DISTINCT ( 'table1'[Sales Person] ),
            DISTINCT ( 'table2'[Sales Person] )
        )
    )
    

    Create one-to-many single direction relationships from this table to your other tables and then use the column from this new table in all of your visuals and in the drill through parameter.

1 Reply

  • Create a sales person dimension table, e.g.

    Sales Person =
    DISTINCT (
        UNION (
            DISTINCT ( 'table1'[Sales Person] ),
            DISTINCT ( 'table2'[Sales Person] )
        )
    )
    

    Create one-to-many single direction relationships from this table to your other tables and then use the column from this new table in all of your visuals and in the drill through parameter.