Forum Discussion

steveindazone's avatar
steveindazone
Frequent Visitor
8 years ago

Formula Not Summing at Hierarchy

Long time user and I've searched all around the web and the forums for an answer but I'm stumped. I'm having trouble getting a measure to sum up to the parent level in my matrix visual. So the measur...
Need Help
steveindazone's avatar
steveindazone
Frequent Visitor
8 years ago

v-chuncz-msft

 

I tried a couple of different variations of SUMMARIZE and they weren't returning any values. I tried the two formulas below:

 

Measure: SUMX(SUMMARIZE(Sheet1,Sheet1[Station],Sheet1[Account]),[Non Returning Dollars])

 

 

Measure 2: SUMX(SUMMARIZE(Sheet1,Sheet1[Station],Sheet1[Account],Sheet1[Date]),[Non Returning Dollars])