Aggregate to higher level

[WCrayger]

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 be 4006.34 for all records.

The relationship to the ISP dimension is the headache, I believe. I thought I could solve this with:

CALCULATE( SUM(ISP Total), ALL(From Company Key)), but this does not work. Any help would be appreciated. 

Thanks in advance.

[TeigeGao]

Hi @WCrayger ,

It's sorry that I can't understand your requirement, could you please share the sample data and expected result to us for analysis?

Best Regards,

Teige

[WCrayger]

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?