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?

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

BartVlek , 

Not clear with the above statement. 

IF(ISBLANK(Table[Webreference]),0,SUM(Table[Turnover]))

 

Regards, 

Manikumar