Forum Discussion

tracytran91's avatar
tracytran91
Icon for Helper III rankHelper III
4 years ago

SWITCH measure in matrix visual

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. 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.