Forum Discussion

markes's avatar
markes
Frequent Visitor
5 years ago
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...
Need Help
  • markes's avatar
    markes
    3 years ago

    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]))
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You probably should just do this with measures instead of new tables or columns.  For example, you can make a simple measure of SUM(Table[Cost]) and use it either in a table visual with both the Color and Type columns, or just the Type column.  I used SUM for example but you could do any aggregation/calculation.  The visual and the column you choose will include the correct rows for the calculation.

 

Regards,

Pat