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

[admin11]

Hi All

I have below chart , which is display accumulated expense by year :-

X Axis :-

Year_sort

Y Axis :-

AMOUNT_EXP_ =

CALCULATE(

SUM(GL[AMT])*1,

FILTER(

GL,

GL[1_EXP]="EXP"

)

)

i get below chart :-

My question is how to modify the expression , so that it will return average yearly expense ?

Paul

[VahidDM · Accepted solution]

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/

[Ashish_Mathur · Accepted solution]

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. 

[admin11]

@Ashish_Mathur it work fine , thank

[admin11]

@Ashish_Mathur 

Thank you for sharing , i get error

[Ashish_Mathur]

You are welcome.  The closing bracket of the SUM function as missing.  I have corrected my post.

[VahidDM · Accepted solution]

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/

[admin11]

@VahidDM 

Thank you very much , it work fine.

Paul

[VahidDM]

Welcome.

Appreciate your Kudos!!
 

LinkedIn | Twitter | Blog | YouTube