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...
Need Help
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.