SWITCH measure in matrix visual

[tracytran91]

Hi friends, 

I have matrix with rows and columns. I would like to have a filter which has options: 

1. Orders

2. Sales

3. Order& Sales

If user select 'Order& Sales', it will show up values of Orders measure and Sales measure. Something like this:

I created a measure table to use SWITCH function. That only works with selected value "Order" and "Sales", I dont know to make it work for 'Order& Sales'

Order&Sales = 
  SWITCH(SELECTEDVALUE('Order&Sales Slicer'[Measure]),
            "Order",[order],
            "Sales",[Sales])

Could anyone help me on this?

Much appreciated for your time. 

[Anonymous]

Hi  @tracytran91 ,

You can replace [Order] and [Sales] with the following measures.

Order_new =
IF (
    SELECTEDVALUE ( 'Order&Sales Slicer'[Measure] ) = "Order"
        && SELECTEDVALUE ( 'Order&Sales Slicer'[Measure] ) = "Order&Sales",
    [Order],
    BLANK ()
)

Sales_new =
IF (
    SELECTEDVALUE ( 'Order&Sales Slicer'[Measure] ) = "Sales"
        && SELECTEDVALUE ( 'Order&Sales Slicer'[Measure] ) = "Order&Sales",
    [Sales],
    BLANK ()
)

Best Regards,

Liu Yang

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