Forum Discussion
undefined
I am looking for the answers for this : Mdxscript(Model) (264,25) calculatiuon error in measure 'xyz'[outflow]:Function 'CONTAINSROW' doesnot support comparing values of type text with the values of type number.consider using the value or Format function to convert one of the values.
Please try this
Total = CALCULATE(ROUND(SUM('Table'[A]) + SUM('Table'[B]) + SUM('Table'[C])+ SUM('Table'[D]) + SUM('Table'[E]), 0))I'm not sure how your data is structured, but you van do this Power Query too if you chaning the table format isn't an issue.
- Highlight all the columns that you want to sum
- Right click and choose unpivot columns. You will be left with the columns that you didn't highlight and two new column. one showing the column names and another with teh amounts.
- Load into the report
- Adapt the measure above to just
Total = CALCULATE(ROUND(SUM('Table'[Value]), 0))
6 Replies
Hi Anonymous
It seems you are trying to compare two columns that have differnt formatting. This could be a number column being compared to what looks like a number column but is formatted as text. Check both columns to see if they are formatted as numbers
Hope this helps
Joe
Can you share the measure that you trying to implement and a screenshot of the column headers in Power Query ? Hopefully then I can help further