Drill Through filters are not working when I am creating a matrix.

[Jaiswal_ji]

Let me describe the whole scenario over here. 
I am using two tables and matching the data between them. They are basic personal details. I have to count the no. of misatches between them according to different fields like customer name, mobile no, address and so on. 

Fields	Mismatch Count	Mismatch %
Customer Name
Mobile No
and so on....

now I have created this matrix by manually create table and fro the mismatch count I have created a column with the conditions such as 
Total_Mismatch_Count =
SWITCH(
TRUE(),
'Fields'[Field] = "Customer Name", CALCULATE(COUNTROWS('Table'), 'Table'[CustomerName_Mismatch] = "N"),
'Fields'[Field] = "CNIC", CALCULATE(COUNTROWS('Table'), 'Table'[CNIC_Mismatch] = "N"),
'Fields'[Field] = "DOB", CALCULATE(COUNTROWS('Table'), 'Table'[DOB_Mismatch] = "N").... 
and so on.

From this I'm getting the desired results of the mismatch counts and mismatch %. 
But the problem is that the filters [CustomerName_Mismatch] = "N" is not working in the drill through page. 
i want to see all the customers with name mismatches.

in my drill through page its the raw data (mismatch_table) where all the fields from both the sources are present. customer_ name_1 and Customer_name_2 with CustomerName_Mismatch .
I am unbale to build any relationship between the matrix view created and the mismatch_table.

as all the of the data are in columnwise. PLease suggest a way to create such a table view with the filters working on the drill through page.

[Anonymous · Accepted solution]

Hi @Jaiswal_ji ,

I've made a test for your reference:

1\Here is my datasource

2\Create a measure for Table

Measure = If( 
    (MAX(Fields[Field]) = "Customer Name" && Max('Table'[CustomerName_Mismatch]) = "N")||
    ( MAX(Fields[Field]) = "CNIC" && Max('Table'[CNIC_Mismatch]) = "N") ||
    (MAX(Fields[Field]) = "DOB" && Max('Table'[DOB_Mismatch]) = "N"),1,0)

3\Filter on this measure

4\Result

Best Regards,

Bof