cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahulmathur7 Helper II
Helper II

Top N By Each Category

Hey guys ,
I have a complex client requirement here ,So i have a data as mentioned below:

Project NameBusinessJob FeeExpected FeeStatusLGReason
Proj1Audit10000 WonName1XYZ
Proj 2Advisory 10000LostName 2

XYZ

Proj 3Risk 10000LiveName 3

XYZ

 

Now the client wants to know what are his top 5 projects in each Business for won,lost and live along with the detail such as LG and reason.According to their logic the won projects should be ranked on the basis of Job fee whereas the lost and live projects should be ranked on the baiss of the Expected fee column.

Right now i am really having a hard time to work on their requirement.Please help me

4 REPLIES 4
Super User IV
Super User IV

Re: Top N By Each Category

Here's your solution. Please bear in mind that the Product Rank only works for selections made from dimensions other than Product. If you start slicing by GL or Reason, which are in Product, it'll not work the way you'd expect it to. But this is OK because this rank is only to be used for this particular scenario.

 

https://1drv.ms/u/s!ApyQEauTSLtOgYNAR-eLVQ_xHNrFLA?e=ewmvbd

 

Best

D

rahulmathur7 Helper II
Helper II

Re: Top N By Each Category

Is it ranking on the basis of Expected fee in Lost statusID?

Super User IV
Super User IV

Re: Top N By Each Category

It's ranking exactly as you wanted it.

Best
D
Highlighted
rahulmathur7 Helper II
Helper II

Re: Top N By Each Category

@darlove Thank you for your time and effort really appericiate it but im really having a hard time to understand the file.
Can we communicate in DM or somewhere else ?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors