Calculate from mulitple colums to catogorize.

[Aurelio]

Good day all 

I have some articles in one table with the different variants. Some article are the same in NL and ES but some are different. To know which articles are different I created a new colum: 

TaalID = (IF(Sheet1[BCItemNumber_NLD] = Sheet1[BCItemNumber_ES],1,0))

So we have this

NL	ES	Difference
P11430	P11430	0
P10220	P10370	1

To calculate the sales I have an active relationship between Valueentries(ItemNO) and the Sheet2(NL) and one inactive relatioship between Valueentries(ItemNO) and the Sheet2(ES).  I want to see the articles with an unique ID in ES but when selecting NL I want to see all the articles even if they have a unique value in ES. 

I tried this but then I only see the unique ES when selecting ES but when selecting NL I don't see the any other values. 

Taal omzet =

var NL = (CALCULATE([Geboekte omzet]))

Var ES = (CALCULATE([Geboekte omzet],USERELATIONSHIP(Sheet1[BCItemNumber_ES],valueentries[itemNo])))

var TAAL = (SUMX(Sheet1,Sheet1[TaalID]))

return

IF(TAAL = 1 ,NL,ES)

[v-zhangti]

Hi, @Aurelio 

Can you provide more sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

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