How to hide display units?

Hi YunJ ,

We can use three ways to meet your requirement.

1. Create a measure to calculate the value / 1000.

value /1000 = CALCULATE(SUM('Table'[value]))/1000

2. Create a measure just show the text of K value.

value K = 
var x = FORMAT(CALCULATE(SUM('Table'[value])),"#-###")
return
LEFT(x,LEN(x)-4)

3. We can create a new table and a slicer to control the units.

Slicer measure = 
var x = SELECTEDVALUE('Table (2)'[unit])
var sum__ = CALCULATE(SUM('Table'[value]))
var y = CALCULATE(SUM('Table (2)'[Column1]),FILTER('Table (2)','Table (2)'[unit]=x))
return
IF(x="K",sum__/y,sum__)

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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