Forum Discussion
how to implement Tableau Context filter in Power BI
how to implement Tableau Context filter in Power BI
yatheeshaworks , Created a video, Hope you are looking for the same
3 Replies
- amitchandak
Super User
yatheeshaworks , Created a video, Hope you are looking for the same
- amitchandak
Super User
yatheeshaworks , Can please elaborate on how this feature work in tableau to tell you the equivalent of the same in power bi.
I have covered a few features here but did not address this one
Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54
- amitchandak
Super User
yatheeshaworks , I got the example for the Top 10 example in the filter context on the tableau website . In power BI it is always included in the context, Exclude from context require coding
This is excluded in the context
All will ensure top 10 is always in
TOP 10 State City all = CALCULATE([Net], TOPN(10,SUMMARIZE(all(Sales), Geography[State], Geography[City]),[Net],DESC), VALUES(Geography[State]), VALUES(Geography[City]))
This is included in the context
TOP 10 State City allsel = CALCULATE([Net], TOPN(10,SUMMARIZE(ALLSELECTED(Sales), Geography[State], Geography[City]),[Net],DESC), VALUES(Geography[State]), VALUES(Geography[City]))