HELP WITH DAX

[LeonardCs]

Hi guys,

I have a table with colummn that contains several numbers and I need to sum them.
It would be easy, but in this colummn I have some words together and I can't take this words.

for exemple:

Values:
10,00

20,00

not yet

30,00

loading

40,00....

How can I creat a measure that just sum the numbers disregarding the words?

[Greg_Deckler]

@LeonardCs Try this. PBIX attached below signature.

Measure = 
    VAR __Table = 
        ADDCOLUMNS(
            'Table',
            "Column1", IF( ISERROR( [Values:] + 0 ), BLANK(), [Values:] + 0 )
        )
    VAR __Result = SUMX( __Table, [Column1] )
RETURN
    __Result

[LeonardCs]

Thank you for responding quickly

[tamerj1 · Accepted solution]

Hi @LeonardCs 
Please try

Measure = 
SUMX ( 
    'Table',
    IFERROR ( 'Table'[Value] + 0, 0 )
)

[LeonardCs]

This was easier than I imagined! Thank you so much 🙏🙏

[Greg_Deckler]

@tamerj1 Beat me by 15 seconds!! And nice one!

[tamerj1]

Lol
It's been a while since I last answered a question in the forum.