Forum Discussion
top5 placenames
i am trying to show top5 placenames in last month based on request id
but im getting error
Anonymous , assume you have measure for last month request closed
request closed = CALCULATE(COUNT(Request[request_id]),DATESMTD(dateadd('Calendar'[Date],-1,MONTH)))
then try rank like
CALCULATE([Requests Closed],TOPN(5,ALL(Place[place_name]),[Requests Closed]),values(Place[place_name]))
TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42
1 Reply
- amitchandak
Super User
Anonymous , assume you have measure for last month request closed
request closed = CALCULATE(COUNT(Request[request_id]),DATESMTD(dateadd('Calendar'[Date],-1,MONTH)))
then try rank like
CALCULATE([Requests Closed],TOPN(5,ALL(Place[place_name]),[Requests Closed]),values(Place[place_name]))
TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42