Forum Discussion

prashant_ora's avatar
prashant_ora
Helper II
8 years ago

whatif analysis

Hi,   I am using tabular model for analysis and need to use whatif analysis paramter. I am not able to enable it. Please let me know how i can do it.   Thanks Prashant
Need Help
prashant_ora's avatar
prashant_ora
Helper II
8 years ago

how to add whatif paramter in data source, can u please tell me?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I don't know your source but all a What If parameter table is is a list of all possible values that you would like to evaluate something on. So, if I wanted to evaluate something for all possible % values in 10% increments I would have a table like:

 

0

.1

.2

.3

.4

.5

.6

.7

.8

.9

1

 

Then you create a slicer based on this table and use SELECTEDVALUE function to get the current value selected.

 

Hmm, one thought, I don't believe that SELECTEDVALUE is supported in Direct Query:

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=sql-analysis-services-2017

 

So, you might have to get creative like just create a measure that is MyValue = MAX('Table'[Column]) for your parameter table.