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,
im trying to get back random lines from an exisiting table. I added a slicer with the country ids, after picking i want to have random rows where country id matches. if i hard code the FilterValue in the TOPN line, i get what i want. also if i hard code the VAR Filter Value, it works. So it has to do with SelectedValue? Relationshop exists, same data format.
Is this what you are looking for?
https://1drv.ms/v/s!AiUZ0Ws7G26Rhl48p2VNmkuvZfk0?e=zyhiAN
not exactly. in my dummy data i have lines for different countries. now i want to pick a country with a slicer and then get SampleSize lines for that country only. However, with selected value (see formula above) i dont get any results.
if you want to create random rows (table) then it will not interact with the slicer
is there a different way to interact?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |