Automatically multiplying data based on individual row values

Hello Anonymous

Here is a measure that should do the trick for you:

Calculation =
SUMX (
    'Table';
    VALUE (
        RIGHT ( 'Table'[SKU]; LEN ( 'Table'[SKU] ) - SEARCH ( "-"; 'Table'[SKU] ) )
    ) * 'Table'[Quantity]
)

With a SUMX the expression will be evaluated over every row and sum up the result.

In this case we determine the length of the string and determine the position of the "-".

When you subtract the length and position you know the amount of characters you need from the right side of the string.

Change the string to a number using the value function and multiply it by the quantity.

If you want to learn DAX I can highly recomend the book: The Definitive Guide to DAX by by Alberto Ferrari and Marco Russo

If you have any more questions don't hesitate to ask.

Kind regards
Joren Venema

Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily. 

Hi Anonymous,

I have created a sample for your reference, please use the measures as below to work on it.

Measure = 
VAR sku =
    MAX ( 'Table'[SKU] )
VAR leng =
    SEARCH ( "-", sku, 1, BLANK () )
VAR lenall =
    LEN ( sku )
VAR num =
    RIGHT ( sku, lenall - leng )
VAR qu =
    SUM ( 'Table'[Quantity] )
var a =  IF ( leng <> BLANK (), num * qu, qu )
RETURN
   a

Measure 2 = SUMX('Table',[Measure])

For more details, please check the pbix as attached.