Forum Discussion

pzinsli's avatar
pzinsli
Regular Visitor
8 years ago

Calculating a Filtered Sum

HI    Let's say I have a table like this, table titled PROFIT AND LOSS DETAILS   ACCT NAME               Line Amount Revenue                      20 COGS                           12 Fringe   ...
Need Help
drewlewis15's avatar
drewlewis15
Solution Specialist
8 years ago

Try this:

 

Measure = CALCULATE(SUM('PROFIT AND LOSS DETAILS'[Line Amount]),'PROFIT AND LOSS DETAILS'[ACCT NAME]="Revenue" || 'PROFIT AND LOSS DETAILS'[ACCT NAME]= "COGS")