Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

calculate when selected in dynamic filter

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 c...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Try this MEASURE

     

    Measure =
IF (
    SELECTEDVALUE ( TableName[IncomeType] ) = "webshop",
    SUM ( TableName[Turnover] ) - SUM ( TableName[cost of adwords] ),
    SUM ( TableName[Turnover] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Anonymous

 

Try this MEASURE

 

Measure =
IF (
    SELECTEDVALUE ( TableName[IncomeType] ) = "webshop",
    SUM ( TableName[Turnover] ) - SUM ( TableName[cost of adwords] ),
    SUM ( TableName[Turnover] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks a lot!