Accompanied Products Sales Frequency

[George1973]

Hi Folks,

I need to get a list of Goods pared (accompanied) with the FOCUSED group of products and namely their frequency in order to get the most frequntly demanded "Package of Goods" sold.

Well, I have looked in the forum and found something similar with two independent tables, one for the products and one for the orders and have tried to use this solution:

Then created the following measure:

Pared_Codes (Count) = 
// Measure for Orders
var _1=SELECTCOLUMNS(FILTER(ALL(TS_OPERATIONS_DOP2),TS_OPERATIONS_DOP2[GOODS_KOD] in SELECTCOLUMNS(ALLSELECTED(C_GOODS),"1",C_GOODS[Good_ID])),"1",TS_OPERATIONS_DOP2[IDLINK])
VAR OrdRs=IF(MAX(TS_OPERATIONS_DOP2[IDLINK]) in _1,1,0)

// Measure for Goods
var _selected=SELECTCOLUMNS(ALLSELECTED(C_GOODS),"1",C_GOODS[Good_ID])
VAR GoodsRes=IF(MAX(C_GOODS[Good_ID]) in _selected,0,1)

return
IF(OrdRs=GoodsRes,DISTINCTCOUNT(TS_OPERATIONS_DOP2[IDLINK]),BLANK())

As a result I'm getting the matrix like this:

(Note: There are only 3 "FOCUSED" Goods selected)

The result seems to work partialy, meaning that: There is filter working per accompaning products codes, but for cross filter does not work..

Please advise the proper solution.

Thanks in advance,