MID function as a variable

monojchakrab , First bring this as a column -RELATED('summary table'[MPU]) 

and then try MID

Hi monojchakrab ,

You want to extract the number from the strings in Size column, right?

It is recommended that you use the LEFT() function to get the number.

Measure = LEFT(MAX('Table'[SIZE]),LEN(MAX('Table'[SIZE]))-6)

You will find that the numbers you propose are text types, you can modify the type manually, or you can add VALUE() to change the number type.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.