topic Re: HELP WITH DAX in DAX Commands and Tips

HELP WITH DAX

LeonardCs — Tue, 27 Aug 2024 19:09:45 GMT

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

40,00....

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

Re: HELP WITH DAX

tamerj1 — Tue, 27 Aug 2024 19:19:05 GMT

Hi LeonardCs
Please try

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

Re: HELP WITH DAX

Greg_Deckler — Tue, 27 Aug 2024 19:19:19 GMT

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

Re: HELP WITH DAX

Greg_Deckler — Tue, 27 Aug 2024 19:20:34 GMT

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

Re: HELP WITH DAX

tamerj1 — Tue, 27 Aug 2024 19:22:12 GMT

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

Re: HELP WITH DAX

LeonardCs — Tue, 27 Aug 2024 19:35:06 GMT

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

Re: HELP WITH DAX

LeonardCs — Tue, 27 Aug 2024 19:36:49 GMT

Thank you for responding quickly