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]))
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi BartVlek 

SalesLoc = IF('table'[web reference] in {blank(),""}, "Internet","Shop")

BartVlek's avatar
BartVlek
Helper II
5 years ago

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

  • BartVlek's avatar
    BartVlek
    Helper II
    5 years ago

    And sorry about the typos ...

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    BartVlek , 

    Not clear with the above statement. 

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

     

    Regards, 

    Manikumar

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi BartVlek 

    In that case use 

    SalesLoc = IF('table'[web reference] in {blank(),""}, "Internet",blank())

     Also, with the question putting a desirable output is a good way for others to understand and help.