Format Values Dax error

[Anonymous]

Hi Experts.

I have the following dax measure which kind of gives me the right answer..

%= if(left(trim(firstnonblank (grp[ReportHeaders], "")),1)="%",

Format (([measure] /100, "##0.0%;(##0.0%);-"),

Format (([measure], "##0.0;(##0.0);-")

)

Which converts  value  -1,800.0 to (1800.0) missing out the comma for thousands and like wide for positive values too.

How do I amend.

[amitchandak · Accepted solution]

@Anonymous , not tested try if this can work

%= if(left(trim(firstnonblank (grp[ReportHeaders], "")),1)="%",

Format (([measure] /100, "#,##0.0%;(#,##0.0%);-"),

Format (([measure], "#,##0.0;(#,##0.0);-")

)