Forum Discussion
Format affects measure
Hi, I have a measure with a switch function. In some cases it returns a percentage, in other cases it returns an absolute value. I used the FORMAT function in DAX to either return the result as a pe...
amitchandak that won't work. You cannot change the format, it always reverts back to Text. Plus in that pane you can only select that it's either a percentage or an absolute number. I want the measure to dynamically switch between a percentage and an absolute number as an outcome.
Thanks
Bas