Multiply column values by a number which can be altered on the dashboard

[jubrna01]

Hello,

I need to multiply each value in a column by a value that can be altered. I have checked this post here

http://community.powerbi.com/t5/Desktop/Multiply-column-values-by-a-number-which-can-be-altered-on-t...

But I guess the purpose in that post was to multiply one single value by another number, not each single value in a column, because when I tried to apply the measure it told me that it can not be applied on multiple values.

Am I missing something?

Thanks in advance

[v-yuezhe-msft · Accepted solution]

@jubrna01,

You can create a measure using similar DAX below.

Measure = MAX('Yourtable'[yourcolumn] )* MAX([alteredColumn])

Also you can take use of what if parameter in Power BI Desktop.

If you still get errors, please share sample data of your table and post your dax here.

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@jubrna01,

You can create a measure using similar DAX below.

Measure = MAX('Yourtable'[yourcolumn] )* MAX([alteredColumn])

Also you can take use of what if parameter in Power BI Desktop.

If you still get errors, please share sample data of your table and post your dax here.

Regards,
Lydia

[jubrna01 · Accepted solution]

In case some one have the same problem, this is the final solution

Total Adj Sales ALT 2 =
SUMX (
    'Table',
    SWITCH (
        TRUE (),
        'Table'[Adjustment] = "b", 'Table'[Sales] * what_if_parameter,
        'Table'[Adjustment] = "c", 'Table'[sales] * what_if_parameter,
        'Table'[Sales]
    )
)