calculate when selected in dynamic filter

[Anonymous]

Case:

I have three different income values (webshop, store and store house) in a dynamic filter.
When webshop is selected I have to calculated the turnover minus the cost of adwords. In the other cases the adwords cost do not have to be subtracted.
Can someone help me out with this?

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Try this MEASURE

Measure =
IF (
    SELECTEDVALUE ( TableName[IncomeType] ) = "webshop",
    SUM ( TableName[Turnover] ) - SUM ( TableName[cost of adwords] ),
    SUM ( TableName[Turnover] )
)

[Anonymous]

Thanks a lot!