Pivot slicer not working properly

[Jaunkalns]

Hello,

I have created pivot tables (including measures from Power Pivot) and added some slicers, but for some reason one of them still keeps returning all of the possible results and just shows 100%.
Any ideas why?

See screenshot below:
View attachment 110362

 

[Alex Blakenburg]

If you right click on slicer and the select Report Connections (about in the middle).
Are all the Pivot Tables ticked ?

 

[Jaunkalns]

Yes, they are (well, all of the tables that I want to be filtered).
If I switch to a different measure in the same pivot table then it is filtered as expected.
These are the two measures used:
M_FA doesn't work
M_BIAS works

 

[jkpieterse]

Have you properly defined the relationships between the tables?

 

[Jaunkalns]

I think so, but I am no expert.
Here's how they look like.

 

[Jaunkalns]

Figured it out - the issue was with the M_FA measure, as the "1-" part of the function applies to the whole dataset and is constant.
So even if the "DIVIDE(SUM([ABS Deliveries]), SUM([Total Deliveries])" part returns nothing, the measure is still calculated and returns 1 (or 100% when converted to percentages).