Applying What if Parameter only to certain value

[android1]

Hi,

I have a table with Hours & Wages Column.

I've applied a What If parameter: What if  = [Wages] * [Wage Increase Value]

I only want to apply this What if to Hours = .5 but i still want to show total of all other hours also.

[MFelix]

Hi @android1,

You need to create a measure with a SUMX something like this:

What if  = SUMX ( Table; [Wages] * [Wage Increase Value])

This will give you the sum of the multiplication values line by line.

Regards,

MFelix

[android1]

Hi @MFelix,

Bit confused by this. I don't see where this is only applying to Hours  = .5 ?

[v-chuncz-msft · Accepted solution]

@android1,

Just add IF Function and SELECTEDVALUE Function inside.