ALLSELECTED and Visual Level Filters

[Anonymous]

Hi, 

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? 

Thanks 

Average Team Size = CALCULATE(AVERAGEX(TeamsAndMembers, DISTINCTCOUNT(TeamsAndMembers[Member]) / DISTINCTCOUNT((TeamsAndMembers[Team]))), ALLSELECTED(TeamsAndMembers))

[v-jiascu-msft]

Hi @Anonymous,

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.

Best Regards!

Dale

[Anonymous]

When I try add a measure from a table to the page level filters it just wont accept it. 

[Ashish_Mathur]

Hi,

Please share a dataset, define the question and show the expected result.

[Anonymous]

I have added a repro of what I want to do to the other question: http://community.powerbi.com/t5/Desktop/Visual-Level-Filter-ignored-by-Measure/td-p/277315. Happy for a moderator to close this question down. 

[v-jiascu-msft]

Hi @Anonymous,

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.

Best Regards!

Dale

[Anonymous]

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