Smart Narrative - how to reference other Values in calculations

[michaelshparber]

Let's say I have created a #Revenue Value and a #Customers Value.

How do I create a third #Avg. Revenue Value wich is #Revenue / #Customers?

I am not talking about free text writing and letting it guess...

My actual calculations are much more complex and I want to to them by steps.

Also, I don't want to create measures, since I use these calculations only in this visual.

There should be some sort of reference rule, like # or @ or smth...

Please help

[VijayP]

@michaelshparber 

Do you want this Way?

[michaelshparber]

Yes, I tried many-many times, including "/", including "devide by",

sometime it worked but sometimes it just shows me wrong calculation.

I think it is "guessing" my measure wrong translating it to words....

I have long-named measures such as "avg. sales per customer diff prev period"

So it is getting confused...

Can I just tell it somehow that I mean a measure, not it's AI guessing...?

[v-xuding-msft · Accepted solution]

Hi @michaelshparber ,

Please try to save it as a value when it returns correct value. Edit the summary 

Because this is still a preview feature, it may not be stabilized. After testing, it works while using "avg. sales per customer diff prev period /  avg. sales per customer diff prev period 2". It returns error message when I change "/" to "divide". And there is not a tag that can check if it is a measure or a column. For now, we only can input natural language in it.