ALLSELECTED and Visual Level Filters

Question

Hi,&nbsp;&nbsp;I have a measure that calculates an average team size. This works fine with Slicers, but Visual Level Filters (set on the right hand side toolbox) have no effect. So if I change the selected teams in Visualization Toolbox, under Filters on the Column, then nothing happens. What am I missing?&nbsp;&nbsp;Thanks&nbsp;&nbsp;Average Team Size = CALCULATE(AVERAGEX(TeamsAndMembers, DISTINCTCOUNT(TeamsAndMembers[Member]) / DISTINCTCOUNT((TeamsAndMembers[Team]))), ALLSELECTED(TeamsAndMembers))

v-jiascu-msft · Answer

Hi&nbsp;Anonymous,&nbsp;Could you please share you .pbix file? Or a sample in TEXT mode and snapshots of the visuals. According to my test, the Visual Level Filters works great with your formula.&nbsp;Best Regards!Dale

anonymous · Answer

I have another&nbsp;http://community.powerbi.com/t5/Desktop/Visual-Level-Filter-ignored-by-Measure/td-p/277315

ashish_mathur · Answer

Hi,&nbsp;Please share a dataset, define the question and show the expected result.

v-jiascu-msft · Answer

Hi&nbsp;Anonymous,&nbsp;As I can see from your another post, you should use a Page Level Filters. Visual Level Filters just works on the visual to which it belongs. Try the Page Level Filters please.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards!Dale

anonymous · Answer

When I try add a measure from a table to the page level filters it just wont accept it.&nbsp;:smileymad:

Forum Discussion

ALLSELECTED and Visual Level Filters

6 Replies

Related content

SUM with FILTER and ALLSELECTED

Optimize AllSelected

Date filters for Visualization

ALLSELECTED but include other filter

ALLSELECTED ignoring page level filters