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]))
     
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.