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