How to drill through rows in a range

Anonymous — Wed, 26 Apr 2023 12:47:52 GMT

Hi Experts!

I have a table Document and my case is I need to show in the table visual via drill through rows that located in a range of other column. Let me explain it by this example:

Here I filtered Project Number = CP-22-3145 and get all related columns.

And when selecting one particular Project Number like this above I want to show via drill through Drawing Number, Project Number, Master Document columns on another table where values related to ALL Master Document values.

Expected result will be(I filtered it manually by taking all Master Document values from previos screen):

You can see here that this table includes not only CP-22-3145, but all Project Numbers and Drawing Numbers that have the same Master Document.

Please Help, appreciate for any ideas. 🙏

Re: How to drill through rows in a range

v-yueyunzh-msft — Fri, 28 Apr 2023 02:36:40 GMT

Hi , Anonymous

According to your description, you want to filter the [Project Number] in a slicer and you want to select one row to jump to another page to show all the data who contains the [Master Document] in pre-Page.

In my thought , first you slicer [Project Number] in first page ,like this:

The [Master Document] has "MD1,13,4" , so in the Page2 will show all the data who contains "MD1,13,4":

If this , here are the steps you can refer to :
(1)This is my test data:

(2)First , we need add a calculated column in this table :

Column = 1

Then we need to click "New Table" to add a calculated table as a assited slicer:

Table = VALUES('Document'[Project Number])

(3)Then we need to put the 'Document'[Project Number] and the 'Table'[Project Number] as a slicer in the first Page1:

We need to put the [Column] in Table visual.And you need to select "Don't Summarize" for this field both in Page1 and Page2:

And then we need to open the Sync slicer for the 'Table'[Project Number] to Page2 and create the same group for three slicers:

(4)Then we can create a measure for Page2 and configure it:

Measure = var _slicer = VALUES('Table'[Project Number]) var _t = SELECTCOLUMNS( FILTER(ALLSELECTED('Document') , 'Document'[Project Number] in _slicer) , "docu" , [Master Document]) return IF( MAX('Document'[Master Document]) in _t ,1,0)

Also you need to put the [Column] field on the "Drill through":

Also , you can close the "Text wrap" in Table visual and then you can drag your mouse to hide this [Column].

Above all , you can meet your need if i did not misunderstand your description. You can also download my test .pbix to test.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

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

Re: How to drill through rows in a range

Anonymous — Tue, 02 May 2023 09:59:13 GMT

Thank you so much for your detailed solution!

topic How to drill through rows in a range in DAX Commands and Tips

How to drill through rows in a range

Re: How to drill through rows in a range

Re: How to drill through rows in a range