Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 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