Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |