Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Cumulative Total of days in Repair

ADPowerBI1_0-1679392555534.png

Hello everyone, I have the above bar chart. 
As we can see the categories along the x axis show the count of how many jobs are in repair. Unfortunately the values all show as the same number as my DAX measure to is incorrect.

 

What I need is to show a chart that sums all the jobs that are above 5 days in repair (all 5+ jobs, all 6+ jobs, all 7+ jobs etc) and shows X repairs in the 5+ days category, then in the 6+ category it will show a count of all jobs that are 6+ days in repair . 

So i need the bar chart to be a pareto. 

 

and then the same for all the following columns. 

 

Is there a way of doing this?

 

Any more info please message here and i'll answer straight away. 

 

1 REPLY 1
andhiii079845
Solution Sage
Solution Sage

Please make a data example with the underlaying data and involved tables. Than what do you expacted (perhaps in a table) as a result and which measure do you used in the moment. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors