Need Help with Sum with Grouping through Dates

[Meghbajaj]

Hello Community,
I have a table with ID, Dates, Fiscal Year, Bonus Type and Amount. The sum function performs the aggregation of amount over all of the dates. However, I require the sum of individual amount only. 

As example, in the image above, the Sum required is of Amount with respect to Bonus Type (Phone + Rent) for each Fiscal Year and ID.

Thanks for the suggestions.

[RaocoSolutions · Accepted solution]

Power bi auto group by on all selected columns, You need to create a measure that ignores the "Bonus Type" from the group by. 

SumOfAmt_ID_FY = CALCULATE(SUM(Sheet1[Amount]),ALL(Sheet1[BonusType]))