Calculation error in measure for Average per Item Category

[SarikaB]

Hell Team,

I am getting the below error while taking out the Average per Item, Could you please help.

Average Per Item = CALCULATE(AVERAGE('Job Ledger Entry'[Total Cost (LCY)]),FILTER('Job Ledger Entry','Job Ledger Entry'[Description]))

Thanks in advance

[VahidDM]

Hi @SarikaB 

You need to complete your filter code:

Average Per Item = CALCULATE(AVERAGE('Job Ledger Entry'[Total Cost (LCY)]),FILTER('Job Ledger Entry','Job Ledger Entry'[Description]="Filter Item/Text"))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Fowmy]

@SarikaB 

Your argument inside FILTER is incomplete, you need assign a value as follows

Average Per Item =
CALCULATE (
    AVERAGE ( 'Job Ledger Entry'[Total Cost (LCY)] ),
    FILTER ( 'Job Ledger Entry', 'Job Ledger Entry'[Description]  = "text")
)