Forum Discussion

RNorth's avatar
RNorth
New Member
3 years ago

Cannont Convert Value Error

Like many others im getting the error that is inicating its returning test and not a value. However both columns (trade price, and % difference) are values and not text so im struggling how to get ri...
MohammadLoran25's avatar
MohammadLoran25
Icon for Solution Sage rankSolution Sage
3 years ago

What do you want to achieve by creating this calculated column?

I cannot understand the logic of the way u have used the CALCULATE Function. 

RNorth's avatar
RNorth
New Member
3 years ago

My intent was to sum the amounts of the trade agreements for each item for each company an multiply it by the % difference using the same filters of item and company. 

  • RNorth's avatar
    RNorth
    New Member
    3 years ago

    Im very new to writing dax and its still a little confusing to me at times so any suggestions are appreciated. 

  • MohammadLoran25's avatar
    MohammadLoran25
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Instead of a calculated column, it seems that you need a DAX Measure.

     

    But I do not know your data model. your 2 columns are in 2 different tables. Provide more details about them as well.

    Then we can handle it using measures.

    • RNorth's avatar
      RNorth
      New Member
      3 years ago

      I started with a measure first and that returned the same error. 

      • MohammadLoran25's avatar
        MohammadLoran25
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Because you wrote the measure wrong.

        Please provide your data model. Tables and the relationships between them.

         

        Thanks