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
haniizz
Helper II
Helper II

helping with DAX -

Hello guys , I need your help , to elaborate I included the table below 

I have gategories ( Mobile-TV-Watches) that has average shipping delay per day , 

but in fact it is not correct for me , because for example in mobile category Samsung delay is 10 days, Apple is 15 , and nokia is 10 days , but in Average shipping culumn it gives me the sum of the average 35, and not the max which should be 15

how to solve this issue 

 

thanks in advance

 

categoryQuantityAverage shipping delay per days
mobile435
TV364
Watches433
1 REPLY 1
lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... I can only help you with meaningful sample data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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