DAX GetDistinctValues Function

/*
Function: GetDistinctValues

This DAX function returns a table with distinct values from a specified column in a dataset.

Parameters:
- tableName: Name of the table containing the column with values
- columnName: Name of the column for which distinct values are to be retrieved

Return Type: Table

Exceptions: 
- If the tableName or columnName provided does not exist in the dataset, an error will be raised.

*/

GetDistinctValues = 
DISTINCT(SELECTCOLUMNS(tableName, "Distinct_Values", columnName))

Usage Example:

Suppose we have a table named 'Sales' with columns 'ProductID', 'Category', 'Quantity', and we want to get distinct values from the 'Category' column.

DistinctCategories = GetDistinctValues("Sales", "Category")

This will return a table with unique values from the 'Category' column in the 'Sales' table.