How to get products which are bought the most along with the selected product/ product category

[Anonymous]

I have a dataset with columns

Item no, Transaction no, Category

There are 2 filters for Caegory and item. IF I select a Category named "Biscuits".

So a table must show all the items that have been bought along (Along in the sense bought in a same transaction) with any item belonging to the category "Biscuits".

Like if the dataset is:

item       trn no         category

A                1               Biscuits

B               1               Chocolates

A                2              Biscuits

C                3              Drinks

B                4              Chocolates

E                4              Biscuits

F                4              Vegetable

G                5              Biscuits

A                5               Biscuits

If I select Biscuits in category filter it should show

item      No of times bought

B             2

F              1

G             1

If I select B in item filter it should show all items bought along with item B

item      No of times bought

A            1

E             1

[amitchandak · Accepted solution]

@Anonymous , You need to have an independent table for category and item for slicer

new measure =
var _tab = summarize(filter(Table, Table[category] in allselected(category[category])),[trn no])
return
calculate(count(Table[Trn no]), filter(Table, Table[Trn no] in _tab))


new measure 1 =
var _tab = summarize(filter(Table, Table[item] in allselected(item[item])),[trn no])
return
calculate(count(Table[Trn no]), filter(Table, Table[Trn no] in _tab))