Filter not being ignored when measure is added included

[Anonymous]

Filter is working when I am not adding total Total NCA PPM (Sales) in the table as shown below. But when I add Total NCA PPM (Sales) into a table, then the visualization ignores the filter and show a lot more other vendor ids.

Can anyone tell me why this is happening please? This is absurd to me 😞

[v-yiruan-msft]

Hi @Anonymous ,

Please review the solution in the following thread and check whether that can help you resolve the problem. If no, please provide the related formula of measure [Total NCA PPM] and some sample data with Text format. Thank you.

DAX problem when adding a measure in matrix it displays multiple rows

Best Regards