Create a SUM measure that sums conditionally (based on a value in another column)
I have been using another table (tableB) to sum specific values in tableA using the following simple DAX:
Sum amount = CALCULATE ( SUM ( tableA[Amount] ), tableB[NewProducts] )
However this works only when Product_code in both tables is numeric. When Product_code is text, I get this error message: Cannot convert value "300a" of type Text to type True/False". How do I go around this?