Power BI Web removes intended, extra spaces in Measure

[MarkusEng1998]

I created a measure that simulates two columns with a percentage and (count). It works fine in the Desktop. But the web version removes the spaces. The obvious solution is to simply use two columns, but the request is to combine both values into one column...

Is there another UNICHAR I should use that won't get trimmed?

Please advise. Thank you!

_rm% = 

VAR vRmPercent = CONVERT(ROUND(AVERAGE('200AttrRmCount'[rmPercent]), 2)*100, STRING)
VAR vLen	= LEN(vRmPercent)
VAR vLenRm  = LEN(CONVERT('200AttrRmCount'[_rmCount], STRING))
VAR vSpace  = 8
RETURN

IF (vLen = 0, "n/a", 
	IF (vLen = 1, "0" & vRmPercent & "%", vRmPercent & "%" )
		& REPT(UNICHAR(127), vSpace-vLenRm) & "(" & [_rmCount] & ")")

[Ritaf1983 · Accepted solution]

Hi @MarkusEng1998 
Try to calculate 2 measures separately and just concatenate them in the basic way with space :
Final_measure = [measure1]&" "&[measure2]

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

[MarkusEng1998]

Sorry, it did not work.

[Ritaf1983]

Can you share 2-3 in your pbix , i will check it on my machine ?

[MarkusEng1998]

combined measure 2 & 3

_rem%Total = VAR vRmPercent = CONVERT(ROUND(AVERAGE('200AttrRmCount'[rmPercent]), 2)*100, STRING)
VAR vLenRm  = LEN(CONVERT('200AttrRmCount'[_rmCount], STRING))
VAR vSpace  = 8
RETURN

[_rm%2] &
 REPT(UNICHAR(127), vSpace-vLenRm) &
[_rm%3]

[MarkusEng1998]

measure 3

_rm%3 = 

VAR vRmPercent = CONVERT(ROUND(AVERAGE('200AttrRmCount'[rmPercent]), 2)*100, STRING)
VAR vLen	= LEN(vRmPercent)
VAR vLenRm  = LEN(CONVERT('200AttrRmCount'[_rmCount], STRING))
VAR vSpace  = 8
RETURN

"(" &
IF (vLenRm > 3, 
		LEFT([_rmCount], vLenRm-3) & "," & RIGHT([_rmCount], 3),
		[_rmCount])
		& ")"

[MarkusEng1998]

measure 2

_rm%2 = 

VAR vRmPercent = CONVERT(ROUND(AVERAGE('200AttrRmCount'[rmPercent]), 2)*100, STRING)
VAR vLen	= LEN(vRmPercent)
VAR vLenRm  = LEN(CONVERT('200AttrRmCount'[_rmCount], STRING))
VAR vSpace  = 8
RETURN

IF (vLen = 0, "n/a", 
	IF (vLen = 1, "0" & vRmPercent & "%", vRmPercent & "%" ))

[MarkusEng1998]

Thank you @Ritaf1983 , I will give this a try!

[Ritaf1983 · Accepted solution]

@MarkusEng1998 
Good luck, 99.99% it will work 🙂

[Ritaf1983 · Accepted solution]

Hi @MarkusEng1998 
Try to calculate 2 measures separately and just concatenate them in the basic way with space :
Final_measure = [measure1]&" "&[measure2]

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