Help with filtering

[BartVlek]

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.

Turnover	Webreference
100
125
75	123456
110	78910
90

[v-lionel-msft]

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.

[BartVlek]

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 · Accepted solution]

@BartVlek ,

Create a Measure like below:

New Measure = IF(MAX('Table2'[Webreference])=BLANK(),0,SUM('Table2'[Turnover]))

[BartVlek]

If I apply this to my case, it works exactly the other way around.

[Anonymous]

Hi @BartVlek 

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

[BartVlek]

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

[Anonymous]

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.

[manikumar34]

@BartVlek , 

Not clear with the above statement. 

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

Regards, 

Manikumar

[BartVlek]

And sorry about the typos ...