Forum Discussion
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 =
...
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
amitchandak
Super User
Super Userribaldo ,
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