Database Reference
In-Depth Information
4. Now we can add a measure by providing an alias name followed by the table
and column reference. The
SUMMARIZE
function, like other functions of the
same type, accepts an unlimited number of columns or alias and measure
pairs as parameters.
5. Let's add the
Sales Amount
measure from the
Internet Sales
table.
6. Make the following addition to the query and run it in the query window:
EVALUATE SUMMARIZE(Customer, [FirstName],
[LastName]
, "Sales Amt", 'Internet
Sales'[Sales Amount])
The results include the new
Sales Amt
measure defined in the query as
shown in the following screenshot:
Search WWH ::
Custom Search