Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
admin11
Memorable Member
Memorable Member

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

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 :-
admin11_0-1654558376086.png

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

 

Paul

2 ACCEPTED SOLUTIONS
VahidDM
Super User
Super User

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/

 

 

View solution in original post

Ashish_Mathur
Super User
Super User

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. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

7 REPLIES 7
Ashish_Mathur
Super User
Super User

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. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur it work fine , thank

@Ashish_Mathur 

admin11_0-1654560447678.png

Thank you for sharing , i get error

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
VahidDM
Super User
Super User

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/

 

 

@VahidDM 

Thank you very much , it work fine.

 

Paul

Welcome.

Appreciate your Kudos!!
Badges.jpg
 

LinkedIn | Twitter | Blog | YouTube 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.