The format of the measure

[Anonymous]

Hi all.

How  can bring the following outcome of my measure?

Basically it is var1 / var2 (var3). But not sure how to wrap it in brackets and separate with the slash.

[themistoklis]

@Anonymous 

Make sure you convert numbers to string. You can either do it in the variable or directly. See example below

var1 = CONVERT(Table[Amount],STRING)

var2 = CONVERT(Table[Amount2],STRING)

var3 = CONVERT(Table[Percent],STRING)

RETURN

var1 & " / " & var2 & " (" & var3 &")"

Or do it directly in a column. See below:

Column = CONVERT(Table[Amount],STRING) & " / " & CONVERT(Table[Amount2],STRING) & " (" & CONVERT(Table[Percent],STRING) &")"

[Anonymous]

@themistoklis , thanks

But getting an error:  "can not convert value '/' of type Text to type true/false"

my measure is in previous comment.

[themistoklis · Accepted solution]

@Anonymous 

remove double ampersand (&&) and put just one (&)

Replace this

CONVERT(Yes_Count, STRING) && "/" && CONVERT(People_Count, STRING) && "("&& CONVERT(Percentage, STRING) &&")"

With this

CONVERT(Yes_Count, STRING) & "/" && CONVERT(People_Count, STRING) & "("&& CONVERT(Percentage, STRING) &")"

[Anonymous]

@themistoklis 

Nevermind, figured out the formatting part myself 🙂 thanks for help!

VAR Percentage = FORMAT(IF (

Yes_Count > 0,

DIVIDE ( Yes_Count, People_Count ), 0), "0%")

[Anonymous]

wow, @themistoklis , thank you! Will have to change my habbits 🙂

Would you also happen to know how to format the following variable so it would bring percentage with no decimal places ?

VAR Percentage = IF (

Yes_Count > 0,

DIVIDE ( Yes_Count, People_Count ), 0)

[themistoklis]

@Anonymous 

Select the Measure from fields section.

Then on Menu on top --> Column Tools -->Format section (put 0)

[amitchandak]

@Anonymous 

assuming they are part of the return

var1 & " / " & var2  & "(" & var3 & ")"

order replace var1,2 and 3 with measures

[Anonymous]

Thanks, @amitchandak 

But getting an error:  "can not convert value '/' of type Text to type true/false"

My measure:

Chat 2 =

VAR People_Count =

CALCULATE (

DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ) - 1,

'user AD'[IsManager] = 1

|| 'user AD'[IsManager] = 0)

VAR min_level =

MIN ( 'user AD'[User Org Level] )

VAR Yes_Count =

CALCULATE (

DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),

'Teams statistics'[Chat] = "Yes",

'user AD'[IsManager] = 1

|| 'user AD'[IsManager] = 0,

'user AD'[User Org Level] <> min_level)

VAR No_Count =

CALCULATE (

DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),

'Teams statistics'[Chat] = "No",

'user AD'[IsManager] = 1

|| 'user AD'[IsManager] = 0,

'user AD'[User Org Level] <> min_level

)

VAR Percentage = IF (

Yes_Count > 0,

DIVIDE ( Yes_Count, People_Count ), 0)

RETURN

CONVERT(Yes_Count, STRING) && "/" && CONVERT(People_Count, STRING) && "("&& CONVERT(Percentage, STRING) &&")"