Forum Discussion

paulalmond91's avatar
paulalmond91
Icon for Helper II rankHelper II
8 years ago

Blank Response on Calculated Column Filtering

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?

 

Need Help

3 Replies

    • paulalmond91's avatar
      paulalmond91
      Icon for Helper II rankHelper II
      8 years ago

      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?