How to modify my expression , so that it can plot average yearly expense ?

Hi admin11 

Can you share a sample of you data in a text format,

BTW, Try this on the same chart:

AMOUNT_EXP_ =
CALCULATE ( AVERAGE( GL[AMT] ) * 1, FILTER ( GL, GL[1_EXP] = "EXP" ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Hi,

You can simplify your measure to this

AMOUNT_EXP_ = CALCULATE(SUM(GL[AMT]),GL[1_EXP]="EXP")

Please show the expected result in a simple table format and share the download link of your PBI file.