Forum Discussion

WCrayger's avatar
WCrayger
Frequent Visitor
7 years ago

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 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.

 

Need Help

2 Replies

  • WCrayger's avatar
    WCrayger
    Frequent Visitor
    7 years ago

    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? 

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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