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])