Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi experts,
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?
My sample tables are like this:
tableA tableB Product_code Amount Product_code 123a 100 125a 125a 120 300a 200 130 300a 90
Solved! Go to Solution.
OK, looks like this measure solves the issue:
Sum amount = CALCULATE ( SUM ( tableA[Amount] ), DISTINCT ( tableB[NewProducts]) )
OK, looks like this measure solves the issue:
Sum amount = CALCULATE ( SUM ( tableA[Amount] ), DISTINCT ( tableB[NewProducts]) )
Try
Sum Amount = CALCULATE ( SUM ( tableA[Amount] ), FILTER ( TableA, TableA[Product_code] = TableB[NewProducts] ) )
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |