Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Exclude one filter

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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , 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