Unit Slicer Help

[Avermaak]

I need some assistance with converting the display units in my visual, from normal amount to Thousand or MIL using a slicer. 

Normally you adjust your visual by changing the display units in the Visualizations editing options or by using a button and bookmark to change the visual when selecting it, but I would like to achieve this with a DAX formula and slicer as there are too many visuals and too many bookmarks already. I would not like to slow down my model.

What I have done so far: 

I have created a slicer table for the slicer pane:

Then I created a column in my data with Display Units 

I then created a relationship between the two:

Then I created a formula to filter the values when I select the appropriate display Unit:

Unit Format =

VAR SelectedOption = SELECTEDVALUE(Billable_COE[Display Units])

VAR Multiplier = LOOKUPVALUE('Unit Slicer'[Multiplier], 'Unit Slicer'[Display Units], SelectedOption)

VAR SummaryTable =

    SUMMARIZECOLUMNS(

        'Billable_COE'[Ad Hoc Bonus],

        'Billable_COE'[Billable COE],

        'Billable_COE'[Business Intitiatives],

        'Billable_COE'[Business Support],

        'Billable_COE'[Corporate Social Resp],

        'Billable_COE'[General Admin & Mng],

        'Billable_COE'[Learning & Development],

        'Billable_COE'[Leave & PHO],

        'Billable_COE'[Market and Brand Development],

        'Billable_COE'[Outstanding Timesheets],

        'Billable_COE'[Overtime],

        'Billable_COE'[Proposal and Client Engagment],

        'Billable_COE'[Rate Differences],

        'Billable_COE'[Wages Non Billable],

        "CalculatedValue", SUM('Billable_COE'[Billable COE]) / Multiplier

    )

RETURN

    MAXX(SummaryTable, [CalculatedValue])

But unfortunately it is not working..... can someone please help me as I am not sure what I am doing wrong.

[olgad]

Hi,
please let me know how you created the column Display units in your data, whats the formula? and ist this only column Billable COE that you want to divide with the selected multipier? How do you want to display the units? 
But to start with, dont use / for division, DIVIDE(SUM('Billable_COE'[Billable COE]) ,Multiplier)