Sales Quantity = SUM ( Sales[Quantity] )

mSales Quantity = SUM ( Sales[Quantity] )

Sales Amount = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] )


mSales Amount = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] )


mSales Amount Multiple Items :=
VAR
MultipleItemSales = FILTER ( Sales, Sales[Quantity] > 1 )
RETURN
SUMX (
MultipleItemSales,
Sales[Quantity] * Sales[Unit Price]
)


Product Sales Amount = 
SUMX (
RELATEDTABLE ( Sales ),
Sales[Quantity] * Sales[Unit Price]
)



EVALUATE
FILTER ( 'Product', 'Product'[Unit Price] > 3000 )



EVALUATE
FILTER ( 'Product', 'Product'[Unit Price] > 3000 )
ORDER BY
'Product'[Color], 'Product'[Brand] ASC, 'Product'[Class] DESC


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]
)