Data Conversion (Number to Currency) not applying inside measure.

[HillUser1]

Inside my report, the user uses a slicer to narrow down to a single specific project. It will then show data related to a single project and evaluate the project status based on a couple of indicators. It appears that when I try to report a number with the SELECTEDVALUE command I do not receive any previous formatting I made in the modeling tab. When I also try to manually apply a conversion inside the DAX I do not get the expected results. The SELECTEDVALUE remains a number. ROUND command works.

What is the proper way to perform this action?

Current Result: Billing was $2229.50 over the actual cost for the past 2 months.

Expected Result: Billing was $$2,229.50 over the actual cost for the past 2 months.

Current DAX Formula:

Measure 1 = 

SWITCH(TRUE(),

ISBLANK(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])),"Calculation Error",

SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])>0,"Billing was $" & CURRENCY(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])) & " over the actual cost for the past 2 months",

SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])<0,"Billing was $" & (ROUND(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])*-1,0)) & " under the actual cost for the past 2 months")

[AilleryO · Accepted solution]

Hi,

Instead of your CURRENCY function, did you try with a FORMAT function ?

FORMAT(myvalue,"$ #,###.00")

Tell us if it works...

Have a nice day

[HillUser1]

Thank you for your help. It worked and is exactly what I needed. 

For Additional information and Options on the format fucntion: 

Other use: FORMAT( 12345.67, "Currency")

Link: https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function