Switch in Tabular Model

[Lstatsea]

I am using a swith in my tabular model and I want to change the display but when I  put format around the measure it comes back blank. Thanks in advance for your assistance and code is below:

Measure Selection:= if(ISCROSSFILTERED('DimMeasure'[Measures]),SWITCH( TRUE(),
 VALUES('DimMeasure'[Measures]) = "Sq Ft",  [Sq Ft],
                VALUES('DimMeasure'[Measures]) = "Revenue Impact",  [Revenue Impact] ,
 VALUES('DimMeasure'[Measures]) = "Deal Count", [Deal Count],
 BLANk() ), BLANK())

I want to format deal count as whole number and sq ft as whole number with thousand separator and revenue impace as currency with no decimal places.

[v-sihou-msft]

@Lstatsea

Can you remove the IF statement and directly use SWITCH() function only?

It seems you want to dynamically display a measure. I suggest you try approaches in links below:

Dynamic Measure Selection in Power BI

Dynamically select measures to be shown on a Power BI visual via slicer

Dynamic Column Based on Slicer Selection 

Regards,