Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago

Gauge Chart - Formula

Hi,

 

What is incorrect in the below formula? I am trying to set a target column but the formula below seems incorrect. 

 

 

Regards

Malvika

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi @MalvikaBhasin,

     

    You can add a calculated column =Orders[Sales]*1.5.

     

     

    Then use the calculated column to create a measure, and use the measure to create the gauge chart.

     


    Best Regards,

    Dengliang Li

     

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

    • MalvikaBhasin's avatar
      MalvikaBhasin
      Helper III
      2 years ago

      Hi,

       

      I seem to bed oing something incorrect. The formula still doesn't work. 

       

      Regards

      Malvika

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi @MalvikaBhasin,

         

        Is the /Sales/ a column in the /Orders/ table?

         

        In my testing, I did not reproduce your problem.

        My calculated column references the /Sales/ column in the /Orders/ table, and no errors are reported using the /SUM/ formula.

         

         

         


        Best Regards,

        Dengliang Li

         

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