Forum Discussion
Solved
Need Help with Sum with Grouping through Dates
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.
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]))
1 Reply
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]))