I created the possibility to select currency in my report. Via the function FORMAT () I want to dynamicly change the format showing a $ or € sign depending on the currency selection. When using DAX ...
Totally agree, I use a lot of switch measures to switch between units and value. I can fix the results using the FORMAT () function but then any sorting I have enabled on a table is lost, it appears to a be a rock and hard place situation.
