Forum Discussion

BartVlek's avatar
BartVlek
Helper II
5 years ago
Solved

Help with filtering

Hi, I have the following issue. I have a colum with turnover, and I have column with webreferences (meaning internetsales). No I would like to know the formula to calculate the internetsales. So if...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    BartVlek ,

    Create a Measure like below:

    New Measure = IF(MAX('Table2'[Webreference])=BLANK(),0,SUM('Table2'[Turnover]))
     
BartVlek's avatar
BartVlek
Helper II
5 years ago

Sorry I did not make myself perfectly clear. From my example table above, I would want the foloowing result:
I would like a new column 'WEBTURNOVER'.
If there is no webreference, the value for that line in the new column should be 0.
If there is a webreference the value for that line in the new column should be the value from the column TURNOVER.

 

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    BartVlek ,

    Create a Measure like below:

    New Measure = IF(MAX('Table2'[Webreference])=BLANK(),0,SUM('Table2'[Turnover]))
     
    • BartVlek's avatar
      BartVlek
      Helper II
      5 years ago

      If I apply this to my case, it works exactly the other way around.