Help with visual error when filter is applied

[ERing]

I'm getting an error in in my table visual when I apply a filter to select a specific dimension.

The visual is a table with 2 columns. The first column is the Actual % and the second column is the measure.

Measures:
Target_Booked_35%_Deviation = [Actual %] - [Target_35%]
Target_35% = .35

Any ideas on what could be causing this?

[Idrissshatila]

@ERing , it seems that in your table there's a N/A value that is affecting the column, if so replace it with zero.

[ERing]

@Idrissshatila  I'm not quite sure how to resolve this. I've tried IF = NA in DAX but that isn't working. Any tips?

[v-xinruzhu-msft]

Hi @ERing 

Did you put the text 'N/A' in the column, if it exists in the column, you need to replace the 'N/A' to  blank or 0, or the data type of the column will be the text instead of number.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.