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 there is a webrefernece, that means it is an internetsale, otherwise it is an sale from the shop.

 

TurnoverWebreference

100

 
125 
75123456
11078910
90 
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]))
     

9 Replies

  • 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

    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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi BartVlek ,

     

    Is this what you want?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.