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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
Users online (27)