Drill through filter is not getting applied on one columns

[kborusu]

I have a master report which contain importjobrowid and sequence number columns. Based on the row selection, it should navigate to the details report. Filter is happening on importjobrowid(24) and it is not filter on sequence number(65) when i select first record.

Master report:

Detail report

[v-luwang-msft]

Hi @kborusu ,

Could you pls share your pbix file ?Remember to remove your confident data.

Best Regards

Lucien

[kborusu · Accepted solution]

Hi Lucien,

               I am able to find the issue. This issue is due to the data modelling where i am using two separate columns(ImportJobid, sequencenumber) to join two tables. One column(ImportJobid) is having active relationship(*-*) and other columns(sequencenumber) is having inactive relationship. Due to the inactive relationship, data is getting aggregated at Importjobid level. I am planning to concate both columns and i will use single column to join the two table.

Regards,

Kali.

[v-luwang-msft]

Hi @kborusu ,

Awesome! You can mark your answer as the correct answer so that users with the same problem can find a solution as soon as possible.

Best Regards

Lucien