Answers for "DAX Code Snippet For Optimized Sales Query"

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