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.
Solved! Go to Solution.
Hi @Anonymous,
You can use that in another measure. But if you'd like to output the result, you need some aggregation functions. Please try this one.
Measure = CONCATENATEX ( VALUES ( Sheet1[Column1] ), [Column1], "," )
Best Regards,
Dale
Hi @Anonymous
Yes, by using for example
SELECTEDVALUE('Table'[Slicer]). This only works with one item selected though. It will return blank() otherwise.
If you use VALUES('Table'[Slicer]) you'll get a one-column table with the values selected in the slicer that you can then use in your measure.
Does that help? Otherwise, if you show what you want to do in your measure we could be more specific
@Anonymous
Sure. Like I said, VALUES('Table'[Slicer]) will get you a one-column table with the all the values selected in the slicer that you can then use in your measure.
Hi @Anonymous,
You can use that in another measure. But if you'd like to output the result, you need some aggregation functions. Please try this one.
Measure = CONCATENATEX ( VALUES ( Sheet1[Column1] ), [Column1], "," )
Best Regards,
Dale
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 |
---|---|
108 | |
97 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |