Measures with scenarios in the same column

[Anonymous]

hi all!

I am struggling with a measure I need.
My table has these columns:

Scenario    Values

Actual	1.000
Budget	1.222
forecast1	4.453
forecast2	4.534
forecast3	3.455
forecast4	3.453
forecast5	5.643
forecast6	5.677
forecast7	4.567
forecast8	5.456

I need to create a measure that calculates the % of growth between any two scenarios selected using a slicer in the report.

Thanks for your help!

Fabian

@Anonymous @Vvelarde @parry2k 

[parry2k]

@Anonymous can you explain what you meany scenarios? And how are planning to visualize the data?

[Anonymous]

Hi @parry2k 

I have a waterfall chart showing the variations between scenarios (every scenario is a different forecast in my data table)

when I choose scenarios on the slicer, the waterfall chart gets updated but I need to show the % of variation between the two selected scenarios in % and $, but the chart does not has this feature, so I need to create a measure that helps me to show these variances.

I hope this helps to understend my problem and thanks for your help