how to implement Tableau Context filter in Power BI

[yatheeshaworks]

how to implement Tableau Context filter in Power BI

[amitchandak · Accepted solution]

@yatheeshaworks , Created a video, Hope you are looking for the same

https://youtu.be/Br8aMr-7Qn4

[amitchandak]

@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]))

[amitchandak]

@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