TOP 5 BusinessUnit , Each business unit top 3 QueryHits want to show below Visual.

[basirve]

Hi Team,
I would like to show Top 5 Business Unit and top 3 Query Names Based on Query Hits% ,
X Axis--> 

Report Level Filters:

Measure:

_Rank_EscalationCall =

IF([%Escalation_Hit] <>0, RANKX(ALL(Denodo_Lawson_Master[Business Unit]),[%Escalation_Hit],,DESC),"")

_Rank_Escalation%_Nexidia =

IF([%Escalation_Hit] <>0, RANKX(ALL(Denodo_QueryHits_Escalations[Query_Name]),[%Escalation_Hit],,DESC),"")

The Business unit top 5 is not showing Properly ?

Could you please suggest on this .

[amitchandak]

@basirve , Try a measure like

Calculate([%Escalation_Hit], keepfilter(TOPN, 2, ALL(Denodo_Lawson_Master[Business Unit]),[%Escalation_Hit], desc))

Power BI Tutorial Series for Beginners Part 42 TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448