Forum Discussion
Concatenate multiple measures into one, increase speed?
I have a series of measures in their own table, I am trying to build a measure that concatenates the outputs of some of these measures into its own measure, for example:
3P = [3PM] & "-" & [3PA] & " (" & Round([3P%]*100,1) & "%)"
This uses 3 measures to return one singular output which for example looks like: 1-5 (20%)
The issue is that when I use this measure in a table it is incredibly memory intensive and slow to the point it is unusable...even with report tables that have few rows (<10), I have no issues using the 3 measures separately in the same table, these render quickly.
Further, if i use the concatenate function with just the measures,e.g.: test = CONCATENATE([3PA],[3PM]), there is no issues, it seems to be the introduction of symbols (i.e. '-', '(',')') that is slowing it down.
Is there a better way to concatenate measures to avoid this issue?
My dataset is built using a star schema so do not think it is a schema issue...
2 Replies
- amitchandak
Super User
JFG123 , Try to create this measure using the measure formulas in a new measure and check do you see any difference. Try to avoid any duplication code across measures
amitchandak this does not improve speed, I have added further comments to post around the use of symbols in the measure which I think is what is slowing it down.
