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

paulalmond91,

 

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

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?

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

    v-chuncz-msft

     

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