EVALUATE DISTINCT('Product'[Color]) EVALUATE VALUES('Product'[Color]) EVALUATE SUMMARIZECOLUMNS ( 'Date'[Fiscal Year], "# NumOfProducts1", COUNTROWS( DISTINCT('Product')), "# NumOfProducts2", COUNTROWS( VALUES('Product')) ) DEFINE MEASURE 'Product' [# NumOfAllColors] = COUNTROWS ( ALL ( 'Product'[Color] ) ) MEASURE 'Product' [# NumOfColors] = COUNTROWS ( VALUES ( 'Product'[Color] ) ) MEASURE 'Product' [# NumOfDistinctColors] = COUNTROWS ( DISTINCT ( 'Product'[Color] ) ) EVALUATE SUMMARIZECOLUMNS ( 'Product Subcategory' [Subcategory], "# NumOfAllColors", [# NumOfAllColors], "# NumOfColors", [# NumOfColors], "# NumOfDistinctColors", [# NumOfDistinctColors] )