Caluclated column not filtering table visual

[Anonymous]

Hi Team,

I have a calculated column returning 1 or 0 when certain IF statements are met.

ContractorOutstanding =

IF(ISBLANK('09 Correspondence'[Acknowledgment Date]),

IF('09 Correspondence'[To Company]<>"Company ABC",

IF('09 Correspondence'[To Company]<>"Company XYZ",

IF('09 Correspondence'[Acknowledgment Required] = 1,
1,0)

)))

When I place this in the Report and use it to Filter the table of records visual it only filters the table with these two IF statements. 

IF('09 Correspondence'[To Company]<>"Company ABC",

IF('09 Correspondence'[To Company]<>"Company XYZ"

For some reason the table visual it is ignoring the filter with these two statements: 
IF(ISBLANK('09 Correspondence'[Acknowledgment Date]) and 
IF('09 Correspondence'[Acknowledgment Required] = 1,

You can see below, it correctly filters the "To Company". The problem is, I only want to see the rows that have a value of 1 when I choose a particular Company that has outstanding records. 

Here is the Filter visual where I have selected a company called "IMA" with 8 Outstanding records. The table visual above should only show the 8 outstanding records when I select the company in the filter visual. 

[v-xulin-mstf]

Hi @Anonymous,

It looks like dax has no problem.
Are you applying other filters to the visuals, or adding other measures?

Best Regards,

Link

[amitchandak]

@Anonymous , Try like

IF(ISBLANK('09 Correspondence'[Acknowledgment Date]) && not('09 Correspondence'[To Company] in{"Company ABC","Company XYZ" }) && '09 Correspondence'[Acknowledgment Required] = 1,
1,0)

[Anonymous]

Hi @amitchandak the formula is correct but the table still is not filtering values = 1 when I choose a specific To Company. 

Why does the table filter by the To Company but not filter when the value is = 1?