What If Parameter Help

[ahines]

Hello, 

I am currently playing around with the new What If parameters and had a question. Does anyone know if you can set the What If Parameter to one specific category?

If I have Category A, B, C and want to see how the What If parameter effected just Category A, can I do that? I know you cant put a visual filter in the field of the what if parameter, but was looking for another way. 

If this is not possible, this should be added to this as soon as possible. 

[Vvelarde · Accepted solution]

@ahines

Hi, the what if parameter create a measure (SelectedValue) 

You can use this measure to combine in another measure with your aggregation by category.

Something like:

In a discount Scenario: 

UnitsSold=SUM(MyTable[Units])

UnitsSold_to_A_with_Parameter =
CALCULATE ( [UnitsSold], FILTER ( MyTable, MyTable[Category] = "A" ) )
    - (
        CALCULATE ( [UnitsSold], FILTER ( MyTable; MyTable[Category] = "A" ) )
            * Parameter[Parameter Value]
    )

UnitsSold with Parameter =
CALCULATE (
    [UnitsSold],
    FILTER ( MyTable, MyTable[Category] <> "A" )
)
    + [UnitsSold_to_A_with_Parameter]

Also you can view this PBIX.

https://drive.google.com/file/d/0B95C8CKdTZE3dnNiTFo3cGF0bW8/view?usp=sharing

 

Regards

Victor

Lima - Peru

[ahines]

Thank you. That is very helpful!