Forum Discussion

ERing's avatar
ERing
Post Partisan
2 years ago

Help with visual error when filter is applied

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?




Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    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's avatar
      ERing
      Post Partisan
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.