topic Re: Cannont Convert Value Error in DAX Commands and Tips

Cannont Convert Value Error

RNorth — Thu, 16 Mar 2023 13:46:46 GMT

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 rid of this.

Re: Cannont Convert Value Error

MohammadLoran25 — Thu, 16 Mar 2023 17:12:23 GMT

Please provide more info including a test data.

Re: Cannont Convert Value Error

RNorth — Thu, 16 Mar 2023 17:17:33 GMT

Here is one of the data sets. The other im pulling from a data cube through a direct query so i cannot screen shot that informatoin.

Re: Cannont Convert Value Error

MohammadLoran25 — Thu, 16 Mar 2023 17:23:39 GMT

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.

Re: Cannont Convert Value Error

RNorth — Thu, 16 Mar 2023 17:26:45 GMT

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.

Re: Cannont Convert Value Error

RNorth — Thu, 16 Mar 2023 17:27:21 GMT

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

Re: Cannont Convert Value Error

MohammadLoran25 — Thu, 16 Mar 2023 17:37:16 GMT

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.

Re: Cannont Convert Value Error

RNorth — Thu, 16 Mar 2023 17:40:07 GMT

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

Re: Cannont Convert Value Error

MohammadLoran25 — Thu, 16 Mar 2023 21:54:40 GMT

Because you wrote the measure wrong.

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

Thanks