Calculate category total value and place value for all subcategory values

[asalazarjr]

Hello, i need help creating a calculated column to show total category value for all respective subcategory values for specific quarter. I've created this calculated measure and i figure it should work once i get the red text correct. Although, im open to suggestions if there is another path. 

Thanks for any suggestions.

[amitchandak · Accepted solution]

@asalazarjr , Try like

calculate(sum(Table[values]), filter(allselcted(Table), Table[category] =max(table[category]) && Table[Quarter] =max(table[Quarter])))
or
calculate(sum(Table[values]), allexcept(Table, Table[category] ,table[Quarter]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.