Drilling through to different views

[Anonymous]

Hi,

I have a table with ID's of 1 through to 16 in the first column. They will require a table/view on another tab to drillthrough to but there are 4 seperate views, so 4 tables in total with 4 different views. Is there a way I can drillthrough to that ID and see that view?

Im aware that bookmarks can sort of do this based on the view, however, its not dynamic enough and it needs to be user friendly so the user knows which ID theyre trying to drill in to. The 1 - 16 has to strictly be on the same page. 

I need it to drillthrough by the ID also, so the user knows exactly which ID theyre going to, as oppose to simply drilling through to E.G. the device table.

Is this possible without creating a whole view and drillthrough for each ID?

Ive included some images below. I hope that makes sense. Thanks in advance

ID	Name
1	test1
2	test2
3	test3
4	test4
5	test5
6	test6
7	test7
8	test8
9	test9
10	test10
11	test11
12	test12
13	test13
14	test14
15	test15
16	test16

[v-juanli-msft]

Hi @Anonymous 

If my understanding is correct, you could create a new table which list all id in one column.

Table =
UNION (
    UNION (
        UNION (
            SUMMARIZE (
                Table1,
                Table1[id],
                Table1[name]
            ),
            SUMMARIZE (
                Table2,
                Table2[id],
                Table2[name]
            )
        ),
        SUMMARIZE (
            Table3,
            Table3[id],
            Table3[name]
        )
    ),
    SUMMARIZE (
        Table4,
        Table4[id],
        Table4[name]
    )
)

Then create relationships as below

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-juanli-msft 

Thanks for your reply. The ID reference table is a Dim table coming from SQL server. The 4 tables I listed would be the 4 different views/tabs. It doesnt look like this is possible without creating a tab for each ID unfortunately.

[v-juanli-msft]

Hi @Anonymous 

You have a table with 16 id and other columns, then you want to show 4 id as a group on different views, right?

Best Regards

Maggie

[Anonymous]

@v-juanli-msft ,

Does that make sense?

[v-juanli-msft]

Hi @Anonymous 

Sorry for late reply.

If i understand you correctly, instead of showing destination page names, it shows which id is drilled through.

It seems impossible.

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft ,

Yes thats right. But the problem is more with the drillthrough. 

Instead of the way in the image below, I need the user to know which ID they're drilling into as oppose to the name of the view, as its done on an ID basis, with there being 4 ID's to each view.

Apologies if I haven't explained very well.

[v-juanli-msft]

Hi @Anonymous 

Do you have 4 tables, but you want all [id] from 4 tables to list in one table?

Best Regards

Maggie