Adding numbers in column by ignoring text

Question

Hello,I have the following columnSales5643N/a22N/aI want to add the numeric values in this column but ignore the text values. Is there any dax for these. I want to create a measure for this calculation. Thank you

parry2k · Answer

NISH72 you can add a&nbsp;calculate column&nbsp;using following DAX and then do sum on this new column
&nbsp;
Sales col to sum = 
IFERROR ( VALUE ( Sales[Sales] ), 0 ) 
&nbsp;

nish72 · Answer

Thanks for reply. Actually I don't want to add a new column the numeric values should be added in the same column ignoring the text. It should look like this after sumSales54N/a67

nish72 · Answer

Can someone please help me with this

v-juanli-msft · Answer

Hi&nbsp;NISH72&nbsp;
Is the last column your expected result of this problem?

Best RegardsMaggie
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft · Answer

Hi&nbsp;NISH72&nbsp;
I can get a result as below so far,
Add an index column from 1 in Edit queries.
Column =
IF (
    [sales number] &lt;&gt; BLANK (),
    CALCULATE (
        SUM ( 'Table 2'[sales number] ),
        FILTER ( 'Table 2', 'Table 2'[Index] &lt;= EARLIER ( 'Table 2'[Index] ) )
    )
)

Please check if it fits your scenario.
&nbsp;
Best RegardsMaggieCommunity Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Adding numbers in column by ignoring text

5 Replies

Related content

Adding Clickable Phone Number

DAX expression ignoring blanks statement when extra filter is added

Adding columns

Adding a column

Adding Row Numbers to a Table