Filter not working on a Measure with own filters

[kaye123]

I created a Measure in which there is a default filetr to use aside from a slicer filter or the page filter. However, data doesn't filter when i to a slicer selection or page filter. What could be teh problem in my code?

Fab Ins = CALCULATE(SUM('ADYAP_Fab'[WafersIn]),'ADYAP_Fab'[PartType] IN { "F" }) + // Internal 

CALCULATE(SUM('ADYAP_Probe'[WafersIn]), 'ADYAP_Probe'[PartType] IN { "D" }, LEFT( 'ADYAP_Probe'[FabSite],2) <> "XX") // External)

[v-rzhou-msft · Accepted solution]

Hi @kaye123 ,

Here I create a sample to have a test your code. I think filter from columns in related table should work. Please make sure column in the slicer filter or the page filter has relationship with 'ADYAP_Fab' and 'ADYAP_Probe'.

My Sample:

Result is as below.

By Default:

With Slicer Selection:

Best Regards,
Rico Zhou

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

[v-rzhou-msft · Accepted solution]

Hi @kaye123 ,

Here I create a sample to have a test your code. I think filter from columns in related table should work. Please make sure column in the slicer filter or the page filter has relationship with 'ADYAP_Fab' and 'ADYAP_Probe'.

My Sample:

Result is as below.

By Default:

With Slicer Selection:

Best Regards,
Rico Zhou

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

[kaye123 · Accepted solution]

Thank you it worked. I had a lot of relationships setup. teh Fab and Probe are connected but only Fab was connected in the category. Removed teh connection between Fab and Probe and connected Probe to category, the slicer worked succesfully.