Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |