Forum Discussion

Romani's avatar
Romani
Helper II
2 years ago
Solved

TOP Achiever Analysis

I have an issue I couldn't solve because I have negative values in my data, and the DAX below cannot rank it. For example, when ranking the ROS KPI and choosing the top 5, it shows only 4. I don't kn...
  • BeaBF's avatar
    BeaBF
    2 years ago

    Romani  this is another topic. Accept the solution and then we can try to fix the issue.

     

    BBF

BeaBF's avatar
BeaBF
Super User
2 years ago

RomaniI probably understood, the first formula must be like this:

ROS Rank = VAR CurrentIndustry = 'Credit Benchmarking'[Industry GB Lease Classification] VAR CurrentCategory = 'Credit Benchmarking'[Category] VAR CurrentSubIndustry = 'Credit Benchmarking'[Sub-Industry (level 4)] RETURN RANKX( FILTER( ALL('Credit Benchmarking'),  'Credit Benchmarking'[Industry GB Lease Classification] = CurrentIndustry && 'Credit Benchmarking'[Category] = CurrentCategory && 'Credit Benchmarking'[Sub-Industry (level 4)] = CurrentSubIndustry ), 'Credit Benchmarking'[Return on Sales (ROS)], , DESC, DENSE )

 

Try.

 

BBF

Romani's avatar
Romani
Helper II
2 years ago

no it doesnt work 

 

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    Romani what it's not working?

     

    BBF

  • Romani's avatar
    Romani
    Helper II
    2 years ago

    what i want when iam chosing the rank without year to reflect on the visuals
    and when iam chosing the industry and rank it reflect too on the visuals 
    i dont want my ranking to be reflect if iam chosing one filter or iam choosing more than one

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    Romani Can you explain with some examples? on the last pbix i 've sent to you, so that we can restart from that point.

     

    BBF

  • Romani's avatar
    Romani
    Helper II
    2 years ago

    I didnt get any answer from your side

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    Romani i wrote you if you can explain the problem with some examples on the last pbix i 've sent to you, so that we can restart from that point.

     

    BBF

  • Romani's avatar
    Romani
    Helper II
    2 years ago

    Please check your email