This looks like a variation of the ABC classification pattern
DAX: conditional count on sum - enquiry
Christian Gihbsson Rosenvinge
21
Reputation points
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 ?
Accepted answer
1 additional answer
Sort by: Most helpful
-
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