Forum Discussion
Solved
Dynamic paragraphs with calculated measures
Hi,
i got stuck in trying to create a dynamic paragraph where some of the values are a result of calculated measure. My measure for paragraph is as below:
Workplace text = "The total employees for " & VALUES('Sheet1'[Address]) & " is " & max('Sheet1'[Employee]) & ". The rent per employee per annum is " & [Rent/Employee] & "."
where [Rent/Employee] = calculate(divide(sum('Sheet1'[Total Rent]),sum('Sheet1'[Employee])),'Sheet1'[Employee]>0)
I am wondering what DAX function should i use to enable the conversion from number to text.
Additionally, i'm not sure if its possible to highlight those dynamic values only in visual cards. For eg.
The total employees for 8 Baker Street is 21. The rent per employee per annum is $2,000.
Appreciate if any of you can help on the above.
Thanks !
Hi slackerhx ,
That's because the VALUES returns a table while the result of a measure should be scala value. You can replace it with MIN, MAX. If you'd like all of them, you can use dax/concatenatex-function-dax to concatenate the values together.
Best Regards,
7 Replies
Hi Dale,
I'm currently unable to project the results in the dynamic paragraph that i'm constructing. Thus, would like to see if there is any way to include the results of a measure in the dynamic text.
Hi slackerhx ,
I'm afraid you can't add a measure in the Text Box visual. You need a Card visual instead.
Best Regards,
