How to divide one dynamic value by another using smart narrative

[clafferty]

I am using smart narrative to add text to my chart.  I need to divide one dynamic value by another to calculate a new value.  Is this possible?  

[IGIL]

Hi, I got the same problem and I cannot create a new measure because if I do it's not selectable. I work with "closed" model provided my IT colls. 

Any idea how to divide in the Dynamic value dialogue?

[v-binbinyu-msft · Accepted solution]

Hi @clafferty ,

Please try below steps:

1. my test table:

Sales:

Rate:

2.add a slicer and a line chart

3. create a measure

Volumn for $ =
VAR cur_rate =
    SELECTEDVALUE ( 'Rate'[To $] )
VAR cur_product =
    SELECTEDVALUE ( Sales[Product] )
VAR cur_profit =
    CALCULATE ( MAX ( Sales[Volume] ), Sales[Product] = cur_product )
RETURN
    DIVIDE ( cur_profit, cur_rate )

4. add a smart narrative ,click "+Value" you can add a new value with your demands

For more details, you can read related document: Smart narratives tutorial - Power BI | Microsoft Docs

Please refer the attached .pbix file

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You would create a new measure for that, and then use that measure in your smart narrative.