I need to use a text value as a number value in Direct Query but I can't find out how

[Anonymous]

Like using SUMX(FILTER(xxxxx;xxxxx[zzz]);xxxx[text but I want number])

[Anonymous]

Try using the Value function it converts text to a number.

Converts a text string that represents a number to a number.

[Anonymous]

Tried to use VALUE but I cant get the correct DAX to work

How and Where to put in VALUE in the formula

Might be easy but I haven't succeded

First time really trying using Direct Query, much easier to use Import