Forum Discussion
Solved
Conditional formatting a switch measure
Dear PBI Community! I have the following switch-measure which is used to show different financial and volume measures within one and the same visual. What I am looking to do is have "(Select...
Use the FORMAT function to get the result, but the best way is to use calculate group
Thank you for the prompt reply! I tried this however get an error, will the Format function make my measure into text?
Error Message:
MdxScript(Model) (110, 1) Calculation error in measure '_Measure_Selection_Cycle'[(Selected) Value]: Cannot convert value '' of type Text to type Numeric/Date.
yes the return value type of format is string