DAX: conditional count on sum - enquiry

Christian Gihbsson Rosenvinge 21 Reputation points
2022-04-12T10:22:58+00:00

I try to calculate the distinct count of items from a table but only until the sum of item amount is in a certain range
count item where amount is in range up to 90%
count item where amount is in range between 90%-95%
and count item where amount is in range between 95%-100%

Any suggestions ?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. Christian Gihbsson Rosenvinge 21 Reputation points
    2022-04-22T10:22:05.927+00:00

    That was the clue I needed - this is defintly a ABC analysis classification problem with a wellknown solution pattern

    0 comments No comments