Forum Discussion
Skilled SharerDynamic Text
What you can do is to create a measure like
TextMeasure = "There are " + [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]
Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this.
Memorable MemberWhat you can do is to create a measure like
TextMeasure = "There are " + [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]
Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this.
Resident RockstarSqlJason, & is the concatenation operator in DAX; + is not overloaded as in SQL.
As an additional point, depending on the measure being used to provide the numeric portion of this string, you may find a need for FORMAT(), which allows you to use a format string to alter the display of a numeric or date value.
- SqlJason
My bad, I forgot to test it before posting :).... Yes you will have to use the & operator as well as FORMAT() based on your needs as greggyb mentioned.
SabineOussiYes, I'm aware about the language, thanks.
I was just hoping to have a more direct solution.