Unable to format a measure

[yasemsem]

I created a matrix table with the values are based on multiple measures. Because I needed to gather a group of measures under a title I had to encapsulate them under another measure  as you see in the below SS ( work around from this post )

However, it looks like the outcome is to have all measures with the same format. Which doesn't look good in my case because I want the 1st and 2nd measures to have a curreny format and the 3rd to be in %.

The goal is for the below measure values to be in $, I tried clicking on it, going to "Measure tools", clicking $, but it didn't work out.

Also tried to enclose it with Currency function in the measure code, but not output as well

Would appreciate any work around..

Thank you.

[MattAllington · Accepted solution]

You have 2 choices. You can use FORMAT([measure], "$0,000").  You can have a different format for each measure in your switch statement. Alternatively you can use a calculation group as I covered here https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/

note, the first solution is text formatted to look like a number, just so you know.