Forum Discussion

TaroGulati's avatar
TaroGulati
Helper III
4 years ago
Solved

Calculation item issue

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 🙂

  • 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.

2 Replies

  • 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.