Forum Discussion

seanstead's avatar
seanstead
Regular Visitor
6 years ago

Scenario analysis: Predefined and user-controlled

Hello everyone

I'm creating some scenario analysis for Altman Z (a company's financial risk), and I've successfully created 2 rodables: EBIT change and sales change. code as follows:

Public changed scenario ?
SUMX( 'AltmanZ (Public)' ,
'AltmanZ (Public)'[Earnings before interest and taxes] * ( 1 + [EBIT Scenario] ) / 'AltmanZ (Public)'[Total Assets] ) * 3.3 +
"AltmanZ (Public)",
'AltmanZ (Public)'[Working Capital] / 'AltmanZ (Public)'[Total Assets]) * 1.2 +
"AltmanZ (Public)",
'AltmanZ (Public)'[Retained Earnings] / 'AltmanZ (Public)'[Total Assets]) * 1.4 +
"AltmanZ (Public)",
'AltmanZ (Public)'[Wealth Market Value ] / 'AltmanZ (Public)'[Total Liabilities]) * 0.6 +
"AltmanZ (Public)",
'AltmanZ (Public)'[Sales] * ( 1 + 'Percentage of Sales Change'[Sales Scenario] ) / 'AltmanZ (Public)'[Total Assets] * 0.999 )

Problem:

my current solution is controlled exclusively by the user. I'm looking to have 2 options - user-controlled and predefined. For presets, I want 3 options: that for each one I would select to say:

option 1: Bit change -10% and change sales -10%

option 2: Bit change -30% and sales change -30%

option 3: Bit change +20% and sales change + 20%

How do I have a preset switch and user control? and then set option 3 to preset?

Thank you!

power bi grab.png