Goal: Generate a list of unique cities.
Both functions return a Table, not a number.
Ready...
💻 DAX Formula
-- Scenario 1: Get Unique Values
EVALUATE Unique_List = VALUES( Customer[City] )
-- Returns a one-column table of unique cities.
-- (Note: VALUES includes the 'Blank Row' if invalid relationships exist)
-- Scenario 2: Distinct Values
EVALUATE Distinct_List = DISTINCT( Customer[City] )
-- Returns a one-column table of unique cities.
-- (Note: DISTINCT ignores the integrity 'Blank Row')