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

i'm already using the card visual, but i'm unable to project the result of the measure in the dynamic paragraph measure. i want to know if there is any DAX expression that can enable the result from the measure [Rent/Employee] to be included in the dynamic paragraph. 

 

I currently don't have issues in projecting column values in a dynamic paragraph measure. 

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,