Forum Discussion

admin11's avatar
admin11
Memorable Member
4 years ago
Solved

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 :-

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

 

Paul

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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's avatar
    Ashish_Mathur
    4 years ago

    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. 

7 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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's avatar
    Ashish_Mathur
    Super User
    4 years ago

    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.