Average YTD Went wrong

[Chanleakna123]

Dear All , 

I have above data , and Average YTD went wrong . it supposed to be 11.485  , 

can you all let me know whether my calculation correct ? 

thx

[v-qiuyu-msft]

Hi @Chanleakna123,

As the AVR YTD measure reference the another measure DOI, we are not clear how DOI values are calculated. It would be better if you could share some underlying sample data not the table visual table with us and clarify corresponding desired results. 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft hi , 

DOI = Divide (Average sale ,Average inventory ) as the attached shown , And those Measure of Average sale and Inventory are calcuated from Table which is the origin value , Average sale = Sum( Average sale ) , that's it. 

and i wanna use those Calcualtion of measure of Averge sale and inventory to be calcuted each other. 
Is there any way that we can go for it ? 

Thanks