Forum Discussion

magnifybi's avatar
magnifybi
Resolver I
6 years ago

How to format my SWITCH Measure as Currency and integer depending on filter

  Measure Selection = SWITCH( TRUE(), VALUES('Measure Dimensions'[Measure]) = "Total Sales", Transactions[Sales Value Total], VALUES('Measure Dimensions'[Measure]) = "Total Quantity", Transacti...
Need Help
SamiNama00's avatar
SamiNama00
New Member
1 year ago

I have the same question , did you find any solution magnifybi ?

JMG241188's avatar
JMG241188
Helper I
1 year ago

Hey,

 

I don't think I did, unfortunately, I believe I just left it as integer numbers.

 

I will try and look back over my model later today and see if I came up with an solution.

 

Sorry I couldn't be of more help.

 

Thanks,

 

Jon