please help remove context

[karo]

Hi,

I would like to show in the table only Top 10 Departments with the Total Sales exceeded the Forecast (Top 10 performers for period - dynamicly selected) and have a possibility to drill down the results to Sub-departments and split it via Months/Weeks with the correct Sub-Totals and Totals.

Applying simple  Visual filters (for top 10 Departments by measure Diff = Sum('Sales Data'[Sales value])-Sum('Forecast Data'[Forecast Value]) is not working correctly  (I am assuming due to the context).  Moreover, I want to show only Top Performers (Diff for Department >=0)

Do you have any hints how to obtain it or links to helpfull videos/articles ?

Thanks in advance,

Karo

[V-lianl-msft · Accepted solution]

Hi @karo ,

See if this helps you:https://blog.enterprisedna.co/find-your-top-3-salespeople-per-region-automatically-in-power-bi-using... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Did not get completely

Refer

https://www.tutorialgateway.org/power-bi-top-10-filters/

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[karo]

@amitchandak  Thank you for your answer, however I have tried it and it is not working in every scenario. I also need to apply the condition to show only those Department where the Diff >=0  to not show as Top Performance department with Sale below the Forcast.

[V-lianl-msft]

Hi @karo ,

Is this problem sloved?
If not, please let me know.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[karo]

Thank you @V-lianl-msft, it was a really helpful example 🙂