Fins all unique values NOT part in one category/Location

[Adrpgs]

Hi there,

New to SQL, DAX and power BI here.

I have a table where I need to find unique values to know what is present in some location and what is not.

exemple below where in Power Bi I need to find all unique SKU values if there are NOT present in the location CCC and I can't find the solution.

Thanks

[Greg_Deckler · Accepted solution]

@Adrpgs Try:

Measure = 
  VAR __SKUs = DISTINCT(SELECTCOLUMNS('Table',"__SKU",[SKU]))
  VAR __CCCSKUs = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Location] = "CCC"),"__SKU",[SKU]))
  VAR __Table = EXCEPT(__SKUs, __CCCSKUs)
  VAR __Result = CONCATENATEX(__Table,[__SKU],", ")
RETURN
  __Result