Forum Discussion

BenTen22's avatar
BenTen22
Regular Visitor
4 years ago
Solved

Query to return results based on highest 80% of column value

Afternoon All,   I'm stuck on how to tackle a problem i've been presented. My source table contains rows of hypothetical opportunties that have been asigned a Most Likely Saving (if they were to be...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi BenTen22 ,

     

    My approach is a little different in that I've used a running total rather than top n. It gets you to 77.5% of the total for your records. See attached pbix file.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi BenTen22 ,

 

My approach is a little different in that I've used a running total rather than top n. It gets you to 77.5% of the total for your records. See attached pbix file.

 

Did I help you today? Please accept my solution and hit the Kudos button.

BenTen22's avatar
BenTen22
Regular Visitor
4 years ago

davehus this does the trick, thankyou!