Quick question for measure format data

[xiumi_hou]

Dear all,

I have below switch measure:

Current Month_Session = SWITCH(

                            MIN('Measure Filter - Session'[Number]) ,

                            --------------------------------------

                            1,[Count_Sessions_Scheduled],

                            8,[Scheduled_without_cancelled_24hrs],

                            2,[Count_Held_Sessions],

                            3,[Count_A1_Assessment_Held],

                            6,[Count_Sessions_Cancel/Missing],

                            9,[Count_Sessions_Cancel_outside 24],

                              10,[Count_Percentage_Missing/Cancelled]

                            )

I need to put this switch measure into one card/graph. However, the red one number is a percentage. If I put this switch measure data format as general, the percentage show 0.38 instaed of 38%. Anyone know how should I let 10 show percentage? Thank you 

[parry2k]

@xiumi_hou you can use format function to define the format for each measure

[xiumi_hou]

@parry2k  Hi Parry, 

                The red one is a measure, and I put the format as percentage. However, when I put all the calculate measures as a new a measure(Current Month_Session), because the other calculate measures in the switch measure is integar, so I have to put the switch measure format as general, How should I make 10(red) as percentage? 

[parry2k]

@xiumi_hou something like this and this post will help

Current Month_Session =
VAR __myValue =  SWITCH(
                            MIN('Measure Filter - Session'[Number]) ,
                            --------------------------------------
                            1,[Count_Sessions_Scheduled],
                            8,[Scheduled_without_cancelled_24hrs],
                            2,[Count_Held_Sessions],
                            3,[Count_A1_Assessment_Held],
                            6,[Count_Sessions_Cancel/Missing],
                            9,[Count_Sessions_Cancel_outside 24],
                              10,[Count_Percentage_Missing/Cancelled]
                            )
 RETURN
IF ( 
MIN('Measure Filter - Session'[Number]) = 10, 
FORMAT( __myValue, "Percent"),
FORMAT( __myValue, "General Number")
)

[xiumi_hou]

Hi @parry2k  Thank for the reply.  After revising, the new measure we created is a "Text" format. However, I would like to put the meaure as the value of bar chart. The bar chart can not recognize text. Any suggestion to revise? Thank you so much!

[xiumi_hou]

UP

[parry2k · Accepted solution]

@xiumi_hou If you want this as a number, you cannot have mixed format for the same measure. You have to create seperate measure for each format option you want.