Forum Discussion

paulalmond91's avatar
paulalmond91
Helper 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'[...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

paulalmond91,

 

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

  • paulalmond91's avatar
    paulalmond91
    Helper 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?

    • paulalmond91's avatar
      paulalmond91
      Helper II
      8 years ago

      v-chuncz-msft

       

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