Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Caluclated column not filtering table visual

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. 
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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?

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

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

     

    Best Regards,

    Link