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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi pzinsli，

 

Try this formula below.

 

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

Here is the result output. 

 

If you need additional help, please share your desired output.

 

Best Regards,

Cherry