differnt formats within a measure?

[Anonymous]

I have this measure in DAX:

SWITCH ( TRUE () ,
 MIN ( 'Dynam'[ID] ) = 5 , DIVIDE ( [Gross] , [Revenue] ) * 100,    
 MIN ( 'Dynam'[ID] ) = 8 ,  [Hours]

)

I would like different formats for 1st and 2nd row... I would like the first one to have one decimal, but not the second one.

Can I do a formatting for one row only? (in either DAX or Power BI)

[AilleryO]

Hi,

Did you try using FORMAT function ?

FORMAT( [measure or var] , "$ 0.0" ) 

Let us know

[tamerj1]

Hi @Anonymous 

you can use FORMAT function to return the desired format of each result separately. For example 

MyMeasure =
SWITCH (
    TRUE (),
    MIN ( 'Dynam'[ID] ) = 5, FORMAT ( DIVIDE ( [Gross], [Revenue] ) * 100, "#0.0" ),
    MIN ( 'Dynam'[ID] ) = 8, [Hours]
)