Blank Response on Calculated Column Filtering

[paulalmond91]

Hi,

I have a calculated column that is outputting inconsistent results.

This is the column:

CALCULATE(MAX('Assigned Assessors'[Assessor ID]),FILTER('Assigned Assessors','Assigned Assessors'[Assessor Type]="A"),FILTER('Assigned Assessors',AND('Assigned Assessors'[Active Assessor]=true(),'Assigned Assessors'[Trainee ID]='Assigned Visits'[Trainee ID])))

95% of the time this produces a value correctly however on some accounts the link filter is resulting in a blank value

'Assigned Assessors'[Trainee ID]='Assigned Visits'[Trainee ID]

Below is an example of this inconsistency. The trainee ID on both tables match, the Active Assessor is set to True and Assessor Type is A but its not producing the expected Assessor ID against Julie Shawcroft.

I've tripled checked all my code and I can't see why no value would be produced. Can you give me any pointers?

[v-chuncz-msft]

@paulalmond91,

This might be caused by invisible characters. Check each filter in the CALCULATE Function.

[paulalmond91]

Hi Sam,

it appears to be the trainee id = trainee id filter that is making it blank. The problem is this needed because it creates the connection between the two tables.

Is there a way to exclude invisible characters?

[paulalmond91]

@v-chuncz-msft

I performed a Transform > Text Column > Clean to make sure and still no improvement