topic Create table with what-if parameters in DAX Commands and Tips

Create table with what-if parameters

John117 — Fri, 05 Nov 2021 22:54:36 GMT

Hello!

I'm trying to create a dynamic table with DAX functions where one of the columns shows the value that user input in the what-if parameter. For example if the user enter these values for what-if parameters:

My table should shows:

I'm tryng to use this DAX function to create the table, but it don't work (the error message is: too many arguments were passed to the SELECTEDMEASURE function. The maximum argument count fot the function is 0):

Any suggestion?

Thank you so much!

Re: Create table with what-if parameters

Nathaniel_C — Sun, 07 Nov 2021 16:20:45 GMT

Hi John117

Try this:

Create a table with one column with the Value names
Create the measure below

I used an IF() but use a SWITCH () if there are more values.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Value table = VAR _curValue1 = 'Value 1'[Value 1 Value] VAR _curTableValue = MAX ( newtable[Value] ) VAR _curValue2 = 'Value 2'[Value 2 Value] RETURN IF ( _curTableValue = "Value 1", _curValue1, _curValue2 )

Re: Create table with what-if parameters

Nathaniel_C — Sun, 07 Nov 2021 16:22:51 GMT

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Re: Create table with what-if parameters

John117 — Sun, 07 Nov 2021 19:39:19 GMT

Hello Nathaniel!

It works, thank you so much!

Re: Create table with what-if parameters

Nathaniel_C — Sun, 07 Nov 2021 19:42:07 GMT

Thank you John117 , it is an interesting problem!

Re: Create table with what-if parameters

Nathaniel_C — Sun, 07 Nov 2021 19:47:08 GMT

Hi John117 ,
BTW here is my pbix if you might be able to use it.
https://1drv.ms/u/s!AgCd7AyfqZtE3z_A6wH2EyvfloHC?e=x3JuXX
Thanks again,

Nathaniel

Re: Create table with what-if parameters

johnChu — Fri, 11 Nov 2022 19:08:26 GMT

Hi Nathaniel_C,

I found this is interesting for learning what if parameter. But if there are three or more what if parameters, how could we retrieve the current value, that is, how to modify _curTableValue statement? If we still use MAX, it always returns the biggest value (value 3 if 3 what if parameter).

thanks