Use measure in a slicer and adjust the data type accordingly

[Anonymous]

I want to use measure in a slicer, and I have foud  a lot of tips on how to do this, and all of them work well. For example (https://community.powerbi.com/t5/Desktop/switch-measure-with-multiple-select-slicer-data/td-p/598650... https://www.youtube.com/watch?v=gYbGNeYD4OY) 

The measure I have used: 

Total = IF (ISCROSSFILTERED('Measure Dim'[Measure]),SWITCH(True(),

VALUES('Measure Dim'[Measure]) = "Number of Sales", WebOrder_Mahn_Cost[TotalSales],

VALUES('Measure Dim'[Measure]) = "Total Cost in €", WebOrder_Mahn_Cost[TotalCost],

BLANK()

), BLANK())

Where TotalSales is a measure for the total number of sales , while TotalCost is a measure for their cost. 

The problem I am facing is that using this method I cannot see TotalCost as a currency type, but rather as decimal when I change the measure in the slicer.

I have tried to use CURRENCY() in the measure and it is still not showing me the currency after the number, and if I put the data type currency for the measure (Total) it will give both TotalCost and TotalSales as currencies, which I also don't want. 

Any way to get around this problem? Best regards

[Greg_Deckler]

@Anonymous First, you do not need to use VALUES in your formula, I would ditch it. 

Second, I do not know of a way to do this. Have gone round and round on this subject in a number of threads and tried all kinds of different ways of getting around this but in the end, have never found a good way to do this other than using FORMAT, which turns things into text which you probably do not want.

[Anonymous]

How should I get rid of Value? Because I defined a table "Measure Dim" with the two names "Number of Sales" and "Total Cost in €" and (as far as my understandning) I need to use Value to match it with the name of the table. 

And how can I use format to show the currency? and if I used it I will probably not be able to use filters on the measure, right? 

Thank in Advance