DAX Code Snippet For Optimized Sales Query
DEFINE
MEASURE Sales[SimpleSum] = SUM ( Sales[Quantity] )
EVALUATE
{
COUNTROWS (
ADDCOLUMNS (
SUMMARIZE (
Sales,
'Date'[Date],
Customer[Company Name],
'Product'[Color]
),
"Test", [SimpleSum]
)
)
}