Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
This is in the context of a KPI, so 95% means that I need to at least get 95% of my boxes to my customer in 8 days. If I don't, I want to see how many more days it would take to reach that KPI.
There are two parts to this issue:
1) I am trying to create a measure that indicates how many days from the Days column (calculated column) it will take to reach 95% of Quantity of Boxes delivered. I am having issues with even making a measure with a running total or running percentage because I don't use actual dates.
2) I need to take that amount of days and see how many days over it is from my deadline of 8 days. (I am pretty sure how to do this, but thought that I would ask anyway.)
The sample is in this sample table, but obviously this is based in PBI, and the Days column is a calculated column that calculates time it took for a certain quantity of boxes to come in. The days it takes and the quantity of boxes on any given day always changes. The deadline does not.
Days | Quantity of Boxes |
1 | 2 |
3 | 3 |
4 | 2 |
5 | 1 |
7 | 1 |
10 | 4 |
11 | 3 |
12 | 1 |
14 | 1 |
@Greg_Deckler Would this be an instance for a loop? I just read a previous article you published regarding this topic and thought it might be applicable! Still looking for an answer!
@Anonymous , I think percentile should help
refr these examples for percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
I had to alter the formula, but with the RANKX, it will not break the ties...
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |