Format the units of a measure in a visual

[dan_yoxall]

Hi

I have created the below table using two measures.  

Billing Price = SUM ( 'Project Hours Booked'[Cost]) * MAX('Fee Factor'[Fee Factor])

Billing Price (cumulative) =
    CALCULATE(
    SUM ( 'Project Hours Booked'[Cost]) * MAX('Fee Factor'[Fee Factor]),
    FILTER(
    ALLSELECTED('Project Hours Booked'[WeekNo]),
    ISONORAFTER('Project Hours Booked'[WeekNo], MAX('Project Hours Booked'[WeekNo]), DESC)
    )
    )

'Project Hours Booked'[Cost] is a currency (i.e. £).  

'Fee Factor'[Fee Factor] is the mark up on the cost and is a decimal number. 

As you can see, both columns are returning values without a currency.  Any suggestions on how I correct this?  I first thought about making 'Fee Factor'[Fee Factor] a currency but I use this in a slicer so don't want to misrepresent the units.  

Thanks in advance.

Dan

[tjd · Accepted solution]

Select each measure.  On the Modeling ribbon, Formatting tab, select the appropriate currency type from Format|Currency.