Forum Discussion
How do I convert a columns datatype in DAX?
Hoping this will be easy to answer. I have a table which contains student results. Because of the different types of result that exist (9 to 1, and A to E), the data type has to be a string. ...
Can you try the following ? :
Total Grades = SUMX( FILTER(YourTableName, ISNUMBER(VALUE(YourGradeColumn))), IF( ISERROR(VALUE(YourGradeColumn)), 0, VALUE(YourGradeColumn) ) )
AmiraBedh
Super User
Super UserCan you try the following ? :
Total Grades =
SUMX(
FILTER(YourTableName, ISNUMBER(VALUE(YourGradeColumn))),
IF(
ISERROR(VALUE(YourGradeColumn)),
0,
VALUE(YourGradeColumn)
)
)