Forum Discussion

SSWADOOD's avatar
SSWADOOD
Helper I
5 years ago
Solved

SUM BASED ON RANKX

Hello, i am unable to get sum using measures based on rankx based on my two filters Top client premium wise and top client claim ratio wise. below is a screenshot of my dashboard i am trying...
amitchandak's avatar
amitchandak
Super User
5 years ago

SSWADOOD , If you can get number value from same tbale you are using TOP 20 , 30, Then try to use TOP like

 

CALCULATE( CALCULATE(SUM(AGENT_COMMISSION[AGENT_COMMISSION])),TOPN( selectedvalue(TOPN[TOPN]),allselected(Date[Date]),CALCULATE(SUM(AGENT_COMMISSION[AGENT_COMMISSION])),DESC), values(GROSSPREMRANK_SLAB[GROSSPREMRANK]))

 

 

refer for how it works

TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

SSWADOOD's avatar
SSWADOOD
Helper I
5 years ago

thanks amitchandak for the reply, the video really helped alot. got it to work

calculate([agentcommbetweendates],
topN(SELECTEDVALUE(CLAIMRATIORANK_SLAB[CLAIMRATIORANK]),allselected(details[policy_num]),[CLAIM_RATIO],desc)
,values(details[policy_num]))

thanks