Exclude one filter

[LD1]

Hi everyone, 

I would like to remove a filter (but not with the formula Removefilter). 

I mean, 

All the report is filtered on the brand. One Brand belongs to a group brand. 

When I have a  brand, i would like to see, all turnover of brand of the group. even if I filter on one brand. 

For example : If we select "chairs" and chairs belongs to a "Kitchen" group, show up turnover of all brand "Tables, chairs, Drawers" etc. because all items belongs to the Kitchen group. 

Is it possible to do it? 

Thanks in advance,

I hope I am clear, 

LD

[amitchandak]

@LD1 , prefer to use an independent table for it - assume item 1

Measure  =

var _tab = summarize(allselected(item1), item[Category])

return

calculate(Sum(Table[Value]), filter(Table, Table[Category] in _tab) )

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE