Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table with some clients and i want to reduce that table in order to get a random 10% sample of clients. How can I do it? (It must be in DAX)
Thanks!
Solved! Go to Solution.
Hi @Anonymous,
You can write something like either of these expressions (assuming your original table is called Clients):
Client Sample = SAMPLE ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] ) Client Sample = TOPN ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] )
Both of these add a column [rand] to the resulting table, which could be removed with SELECTCOLUMNS if needed.
Regards,
Owen
Hello everyone!
I am trying to filter the FIRST N rows of a table dynamically (NOT TOP N, FIRST N ROWS!). For instance; lets say I have a table with 20 records. I would like to reach the first 5 rows without doing any ranking, sorting or any other process, just want to get first 5 rows whatever information are in those rows. I also need a slicer to select the N dynamically, so would be awesome if you could help me out about this.
Cheers!
Solved! Thanks for your consideration.
Cheers!
What was the solve? was it the solution noted above? Thank you.
Hi @Anonymous,
You can write something like either of these expressions (assuming your original table is called Clients):
Client Sample = SAMPLE ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] ) Client Sample = TOPN ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] )
Both of these add a column [rand] to the resulting table, which could be removed with SELECTCOLUMNS if needed.
Regards,
Owen
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |