Appended Tables giving incorrect blanks for Countax HAAAALP!

[Anonymous]

Hi All, 

I've appended two tables and need to count the number of times "COMPLETE" appears in the 'Star 1-Completed' column.

As seperate tables the countax measure was working, but when I try to countax in the appended table I keep getting '(Blank)'. This is the formula I"m using in my measure: 

Countax = COUNTAX('Appended - Service User & Star Data', 'Appended - Service User & Star Data'[Star 1 - Status] = "COMPLETE")

I've checked the Format and its text in both instances which shouldn't be a problem with these (?)  

Also tried these two and still getting (Blank): 

1. UsingIFColumn = if('Appended - Service User & Star Data'[Star 1 - Status]= "COMPLETE",1,0) but that's giving me a (Blank) as well. 
2. CountRows = CALCULATE(COUNTROWS(('Appended - Service User & Star Data')), 'Appended - Service User & Star Data'[Star 1 - Status]= "COMPLETE")

The answer it should be giving is 2231. 

Ive attached a sample file. 

[ImkeF · Accepted solution]

Hi @Anonymous  

that's due to a "false" relationship between the append-table and your Calendar-table in combination with your page-report filter.

Your're combining a date with a dateTime-field and therefore not matches are found.

If you then exclude all empty fields from the CALENDAR-table you'll get blanks.

Remove the report-level filter and you'll see that one figure returns correct results.