Now to show the calculation items in their respected selected measure format, we have used FORMAT STRING option and it worked.
But after Microsoft support guys suggestion, we have removed that beause its causing huge performance issue keeping model size and the amount of data we are dealing with in mind.
Now the major issue here in these calculation items is,
for Diff% if we dont mention that FORMAT STRING as "%" then it would jus give whatever the measure we selected, that measure's format.
Like if i select Revenue as a measure which is Currency format, then even Diff% also shows the Currency%.
We tried to use FORMAT() function to convert it, but it also degrades the performance and it converts the values into STRING which can not be used in any another visual than except matrix and table visual.
So keeping all these limitations in consideration, client is agreed to show the DIFF% values in one decimal without % symobol
like ex: 98.23
We been struggling to get this thing done.
Any suggestions or help if i get, that would be much appreciated.