Forum Discussion

slackerhx's avatar
slackerhx
Helper 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
Microsoft Employee
7 years ago

Hi slackerhx ,

 

Why would you like a DAX function to convert the number to text?

Regarding your second requirement, I would suggest you create an idea here.

 

Best Regards,

slackerhx's avatar
slackerhx
Helper II
7 years ago

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.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi slackerhx ,

     

    I'm afraid you can't add a measure in the Text Box visual. You need a Card visual instead.

     

     

    Best Regards,

    • slackerhx's avatar
      slackerhx
      Helper 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
        Microsoft 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,