Forum Discussion

ribaldo's avatar
ribaldo
Frequent Visitor
4 years ago
Solved

Summarize data calculated at bottom level

Hello, I'm stuck on this summarization problem: I've a calculation with some conditions based on a Sales Table and I just want to aggregate by Customer:   VAR selGoal = 5000 VAR deltaYtd = ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    ribaldo ,

    First create a measure without this Say M1

    SUMX (
    SUMMARIZE ( 'Dim Customer', 'Dim Customer'[Customer Desc], "value", lvl0Calc ),
    [value]
    )


    Then create a new measure and use above calculation using the measure(M1) you created without that and try

ribaldo's avatar
ribaldo
Frequent Visitor
4 years ago

amitchandak 

Thank you for your answer.

I created a measure M1 :

 

 

M1 = 
VAR selGoal = 5000 
VAR deltaYtd =
    IF ( [Act YTD] > selGoal, ( [Act YTD] - selGoal ) )
VAR deltaMon =
    CALCULATE ( [Act] - deltaYtd )
VAR lvl0Calc =
    CALCULATE (
        IF ( deltaYtd > 0, IF ( deltaMon < 0, 0, deltaMon ), [Act] ),
        FILTER ( 'Dim Customer', HASONEVALUE ( 'Dim Customer'[CUSTOMER_ID] ) )
    )
RETURN
    lvl0Calc

 

and then a M2 using M1:

 

 

M2 = 
    SUMX (
        SUMMARIZE ( 'Dim Customer', 'Dim Customer'[Customer Desc], "value", [M1] ),
        [value]
    )

 

 

But with no success:

I did something wrong?