Forum Discussion

BartVlek's avatar
BartVlek
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper II
5 years ago

Thank you! What does it loojk like if I only need internetsales?

BartVlek's avatar
BartVlek
Icon for Helper II rankHelper II
5 years ago

And sorry about the typos ...