Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I am trying to use DAX to check for multiple variables in a list. For example:
I have a drop down list with "Banana", "Apple", "Orange", "Kiwi", "Pear" as selectable options which control a chart. I can currently extract individual selections with a variable SelectedValue(Fruits[Names]).
However, when I select Banana and Apple, I want to have a variable that picks this up (like, prints selected value "BananaApple" or something. I am not sure what function I should use for this.
Thanks!
Try something like:
Measure = CONCATENATEX(VALUES(Fruits[Names]),",")
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |