Average YTD of each Categories in Each Month

[Chanleakna123]

hi , how can i use the YTD Average Calculation as per each categories ? 
now it sum up all number , this is not what i expect. 

can you help me ? 

[v-qiuyu-msft]

Hi @Chanleakna123,

Would you please clarify "YTD Average Calculation as per each categories"?  It would be better if you could share some sample data and show corresponding desired results. 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

hi , 

below is AVR YTD calculation . 

QSPEC Calculations	YTD	Jan	Feb
DOI Finished Goods	11.50	9.16	13.85
Manufacturing Cost Per Unit Case	0.16	0.19	0.13
DTF (Distribution,Transportation and Fleet) Cost per phys Case sold	0.19	0.19	0.19

[v-qiuyu-msft]

Hi @Chanleakna123,

Do you mean to get average value of YTD (11.50 +0.16+ 0.19)3? If it is, you can create a measure below: 

AVETotal= AVERAGEX(SUMMARIZE('table',[QSPEC Calculations],"t",YTD),[t])

Best Regards,
Qiuyun Yu 

[Chanleakna123]

Hi @v-qiuyu-msft

you see my excel file YTD , Jan , Feb , 

and the YTD Calculation is =AVERAGE(D52:E52)   

i only need horizontal calculation of Jan + Feb , it's like YTD Average. 

and my purpose is to get my excel file like the file in BI i used 

but i failed to the total YTD Average of Horizon of each KPI , 

[Chanleakna123]

Hi @v-qiuyu-msft 

i used below calculation , and the result turn zero. 

do i make some mistake here ? Kindly let me know 

average_ytd =
AVERAGEX(SUMMARIZE(Metrics,Metrics[Data Input],"Total TY",[YTD]),[Total TY])

[Chanleakna123]

@v-qiuyu-msft hi , still i didn't get the solution on this calculation.