Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
| category | Quantity | Average shipping delay per days |
| mobile | 4 | 35 |
| TV | 3 | 64 |
| Watches | 4 | 33 |
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