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,

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

Hi slackerhx ,

 

Can you share some snapshots or a dummy sample? Please refer to the snapshot below. It seems fine.Dynamic-paragraphs-with-calculated-measures

 

 

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,