Forum Discussion
Solved
Right approach to summary data?
Background I'm used to complicated Excel formulas but am trying to understand Power BI's approach to things so I can make reports. I have a big Table of fruits with columns like "type" (e.g. "ap...
Much later, I found that measures using "REMOVEFILTERS" like the following solve this problem in the way I intended. For example, something like:
CALCULATE(SUM(MyTable[Cost]), REMOVEFILTERS('MyTable'), VALUES(MyTable[Fruit]))
One approach I found that seems to meet my needs, but maybe isn't best-practice, is to make a reference to the original Table query and use "Group by", as described in Mi2n 's answer to "SUM rows" .