Forum Discussion
Aggregate to higher level
I'm trying to aggregate the below to the Order Number level (Test measure). This will be part of a % allocation of client invoice calculation down stream. The desired output of the Test measure will ...
I was able to accomplish the desired task by building a summary table:
ISP Invoice Summary =
SUMMARIZE(
'ISP Invoice'
,'ISP Invoice'[Work Order Number]
,'ISP Invoice'[Extended Invoice Total Amount]
)But still want to know if there's a more efficient way to do this in a single measure statement, one that won't use as much memory as a calculated table perhaps?