Count function not applying values in chart

[Anonymous]

First time question-er here.

I'll try to keep it simple.  Can't share data due to privacy issues.

1)Center table: list of invoices that have gone through a center

2)Dispute table: list of invoices that have had disputes

3)Fact table: all invoices, sales $

The first two tables are related in a 1:* relationship to the fact table

I have added two columns to my Fact table that are simply a yes/no based on whether that invoice appears in the corresponding tables: "Is Dispute Invoice" and "Is center invoice"

formula example: Is Dispute invoice = if(isblank(related('Dispute info'[Dispute Invoice ID])), "No", "Yes")

I have TRIED to create a measure that looks at the % of disputes: 

% disputes = divide(count('Dispute info'[Dispute Invoice ID]),CALCULATE(sum(Sales $], filter('Fact', 'Fact'[Is dispute invoice]="yes")))

This seems to work fine until I drop in (to my table visual) the "Is Center Invoice".  Say there are a total of 9 dispute invoices.  The first table I attached calculates this correctly.  The second table is still using a count of 9 invoices, even though I've dropped in the Center yes/no column.  How do I get the count function to take into account any columns I may drag into the visual?!

Really hope this makes sense...

[v-chuncz-msft]

@Anonymous,

You may try using ALL Function, ALLEXCEPT Function and ALLSELECTED Function.

[Anonymous]

Thanks for replying... Those actually seem to make it worse.  I was wrapping those around the 'Fact' table after the FILTER function.