What If Paramteter Per Each Selection in Category

[Anonymous]

Hi All,

I have a dataset with several location

I have a slicer to select certain locations

Is there a possibility to assign a what if per location I choose?

Location

LA

Miami Select

NY Select    

Boston

Houston - Select

What if selection type ( Buy , Sell)

Miami = Sell

Ny = Buy

Houston = Buy

 so then I can

IF(Selectedvalue = "buy", [Measure Buy], [Measure Sell]

Any ideas?

[mahoneypat · Accepted solution]

Yes.  You can make add a column with an IF or SWITCH to have Buy/Sell etc in the correct rows, or make a disconnected table with your slicer options and the Buy/Sell column.  You just need the slicer selection to filter the Buy/Sell column somehow.

You can then use MIN(SlicerTable[BuySellColumn]) in your expression in place of "selectedvalue".

Regards,

Pat