Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
I have error when i use Calculate , sum filter to get total Score by customer .
" The fucntion SUM cannot work with values of type String." error appear when i crate new columun with Dax formula
"TotalScore by Customer = CALCULATE(SUM(Score ), ALLEXCEPT (Cusotmer)))"
How should i fix errror ?
Thanks in advance for your help.
Regards,
SweZin
Solved! Go to Solution.
There are 2 errors here, first the data type of Score column is text, you can use power query for that or create a new calculated column using VALUE or do some maths operation on it like multiplyin the column by 1, second you haven't used ALLEXCEPT correctly you need to at least specify 1 column in ALLEXCEPT from which filters will not be removed, otherwise just use ALL ( Customer ).
Actually my dax formula as followed
TotalScore = CALCULATE(SUM(Table[Score],ALLEXCEPT(Table,Table[Customer]))
The data type is Text
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |