Question
Dax measure error in a table with 100 rows but not in one with 50 rows
I have the following PowerBI file with 2 tables.
One of the tables contains 50 rows, and the other contains 100 (both tables have the same values; only the number of repeated rows changes).
I also have the following formula:
Indis = SUMX(
FILTER( ‘Table50rows’,
‘Table50rows’[cfId] = 10029 ),
VALUE(‘Table50rows’[fieldValue])
)
The problem is that the formula works correctly with the table of 50 rows, but it gives me the following error with the table of 100 rows:
MdxScript(Model) (17,5) Calculation error in measure: Cannot convert value 'N0' of type Text to type Number.