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