Forum Discussion

slackerhx's avatar
slackerhx
Icon for Helper II rankHelper II
7 years ago
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 emplo...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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,

slackerhx's avatar
slackerhx
Icon for Helper II rankHelper II
7 years ago

Hi Dale, 

 

I've received the error: 

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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,