Calculation item issue

[TaroGulati]

Hi guys,

I am having some difficulty with format of my measures using calculation items. 

I have created a calculation item using selected measure function. issue is that it is implementing format on all the measures present in the visual. 

This is the table which i use to define the format:

This is my simple measure:

This the expression and format that i inserted in the caluclation item:

This is the result:

Value 1 and value 2 both are same measures. calculation item is applying format on both measures but i want it only on one measure. 

Is there any ways to exclude the specific measure inside calculation item?

Thanks in advance 🙂

[TaroGulati]

@johnt75 thanks

[johnt75 · Accepted solution]

You can do a check inside both the calculation item expression and the format string using ISSELECTEDMEASURE or SELECTEDMEASURENAME, then take whatever action is appropriate.