Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I'm new to Power BI, and I have a bunch of deliveries in a delivery table that I'm trying to graph with an on time delivery approach. I've figured out how to use the bin function to group my data together by month, and in turn group my three possible job statuses by status as well, but from there, I do not understand how to write a formula to calculate them. Ultimately I'm looking to create a graph that shows month and on time delivery percentage. Any assistance would be gratefully appreciated!
Could you supply some raw data or sample data and explain how on time is calculated? It sounds like what you want is a measure like:
MyPercent = CALCULATE(COUNT([Job]),FILTER(Table,ALLEXCEPT([Shipped_Date],[OTD_Status]))) / CALCULATE(COUNT([Job]),FILTER(Table,ALLEXCEPT([Shipped_Date])))
Something along those lines.
Here is a snapshot of some of the data. I've used a column (OTD_Status) to calculate whether the ship date was ontime/late/early. At least that's how I'm used to doing it in MSQuery/Excel. This is data that comes directly out of our SQL Database.
So far the best I have come up with calculates the number of status' that meet the "Early" requirement, as you can see in the attached screenshot. At this point it is counting all of them without factorying the date that I have filtered in the first column of this table. Ultimately this group of dates (months) can/will change as the user uses the slider bar.
Early = CALCULATE(COUNTA('vw_PBI-OnTimeDelivery'[OTD_Status]),FILTER(ALL('vw_PBI-OnTimeDelivery'),'vw_PBI-OnTimeDelivery'[OTD_Status]="Early"))
You want to create your calculations as measures rather than columns. The binning that you appeared to do manually(?) can be accomplished with a date table (use the CALENDAR function).
Can you provide some of the raw data that you are working with?
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |