Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I want to be able to populate the Category column depending on the values selected by the slicer.
Slicer 1
1, 2 or 3
Slicer 2
4, 5 or 6
Value | Category |
1 | A |
2 | A |
3 | A |
4 | B |
5 | B |
6 | C |
7 | C |
Category =
var category_value_A = selectedvalue([Slicer 1])
var category_value_B = selectedvalue(Slicer 2])
return
switch(TRUE, [Value] <= category_value_A, "A",
[Value] <= category_value_B, "B",
"C")
I have tried the code above and it only works for the first condition and then exits the switch.
Hi @theaddies ,
May I ask if your [Slicer1] and [Slicer2] are the following two columns?
Here are the steps you can follow:
1. Create measure.
Measure =
var category_value_A = MAXX(ALLSELECTED(Slicer_Table),[Slicer1])
var category_value_B = MAXX(ALLSELECTED(Slicer_Table),[Slicer2])
return
SWITCH(
TRUE(),
MAX('Table'[Value])<=category_value_A,"A",
MAX('Table'[Value])>category_value_A&&MAX('Table'[Value])<=category_value_B,"B",
"C")
2. Result:
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
Each slicer is a generated series. The Maxx function does not work as it selects the final value in the series.
Try the below.
Category =
var category_value_A = selectedvalue([Slicer 1])
var category_value_B = selectedvalue(Slicer 2])
return
switch(TRUE, [Value] <= category_value_A, "A",
[Value] >= category_value_B, "B",
"C")
User | Count |
---|---|
64 | |
59 | |
47 | |
32 | |
31 |
User | Count |
---|---|
84 | |
73 | |
52 | |
50 | |
44 |