Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
User | Count |
---|---|
101 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |