Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Average in a table per item

Hi    The avarage cost doesn't work - see beneath:     The cost is calculated from quantity and line amount. The avarage cost is calculated as (but it does not work - in the above photo the...
Need Help
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi ElenaJohansen,

According to your description, my understanding is that you want to calculate the average data based on the item id. In this scenario, we can use the following DAX query:

Average cost = CALCULATE(AVERAGE(Excel[Cost]),FILTER(ALLEXCEPT(Excel,Excel[Item ID]),'Dates'[MonthYear] = thisYear))

Best Regards,

Teige

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi TeigeGao 

     

    I cannot use the DAX query - it tells me following:

    Hope you can help me

     

    Best regards

    Elena Johansen