What if parameter doesn't calculate the right results

[klehar]

Hi,

I'm trying to calculate a column called Amount 2 which would be Amount * Percent

I want the percent value to come from 'What If' parameter
I also want this to be a part of a new table and hence i have written an addcolumns function.

I want that when i change my 'what if' slicer, it should change Amount 2, but it always resorts to the default value of 20% (0.2)

PBIX File Link:

Calc Table = 
VAR Percent1 = 'Percent'[Percent Value] 
/*
Percent value comes from my What if paramter
Percent Value = SELECTEDVALUE('Percent'[Percent], 0.2)
Percent = GENERATESERIES(CURRENCY(0), CURRENCY(1), CURRENCY(0.01))
*/

RETURN
ADDCOLUMNS('Table',
"Amount 2", 'Table'[Amount] * Percent1)

Result:

[v-yetao1-msft · Accepted solution]

Hi @klehar ,

Because the value of what if parameter is dynamic, multiplying the value of what if by the value of another column can only create a measure .

Amount 2 = SUM('Table'[Amount ])*'Percent 1'[Percent 1 Value]

If you do not specify a value, it is the default value 0.2 . Otherwise, the specified value is multiplied by the column .

The effect is as shown:

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[klehar]

@PhilipTreacy  or @Phil_Seamark or @Greg_Deckler can you please help.