--  SAMPLE returns a given number of rows from a table expression.
--
--  The rows are evenly chosen following the order provided
--  in the third and fourth arguments
DEFINE
    TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
SAMPLE ( 3, SampleData, [Value], ASC )

EVALUATE
SAMPLE ( 3, SampleData, [Value], DESC )

-- Because SampleData has 8 elements, the elements considered are in position 1, 5, 8
-- The second query returns 5 instead of 4 because the sort order is descending
-- SAMPLE is deterministic when used over the same table with the same argument

--  SAMPLE returns a given number of rows from a table expression.
--  SAMPLE can be used with string columns.
EVALUATE 
    VALUES ( 'Product'[Color] )
ORDER BY [Color] ASC

EVALUATE 
    SAMPLE ( 5, VALUES ( 'Product'[Color] ), 'Product'[Color], ASC )
ORDER BY [Color] ASC

--  SAMPLE returns a given number of rows from a table expression.
--  SAMPLE can be used with tables.
--  The sort order can be defined by one or more columns.
EVALUATE 
    SAMPLE ( 5, 'Product', 'Product'[Color], ASC, 'Product'[Brand], ASC )
ORDER BY 'Product'[Color] ASC, 'Product'[Brand] ASC

EVALUATE 
    SAMPLE ( 5, 'Product', 'Product'[Brand], ASC, 'Product'[Color], ASC )
ORDER BY 'Product'[Brand] ASC, 'Product'[Color] ASC

-- The results are different because the sort order is by Color and then Brand 
-- in the first query, and by Brand and Color in the second query