Forum Discussion

cghanta's avatar
cghanta
Helper I
1 year ago
Solved

Average Calculation

I have a table UPS and a column Age   The Power BI has a slicer based on column location I want to find Average Age from the column Age, ignoring the slicer and display the measure in the report...
Need Help
  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    Hi cghanta 

    Can you please try the below DAX.

    CALCULATE(
    AVERAGE(UPS[Age for Avg]),
    ALL(UPS[Location]), 
    UPS[Age for Avg] <> 0
    )


     




    If this answers your question, kindly mark it as the solution.

  • xifeng_L's avatar
    xifeng_L
    1 year ago

    Hi cghanta 

     

    You also can try below measure:

     

    CALCULATE(AVERAGE(UPS[Age Avg]),FILTER(ALL(UPS), UPS[Age for Dual UPS Avg] <> 0))

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

  • cghanta's avatar
    cghanta
    1 year ago

    Both the solutions from xifeng_L and mdaatifraza5556 worked, Thank you both.
    I am not sure how to select both the replies as accepted solution

mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

Hi cghanta 

Can you please try the below DAX.

CALCULATE(
AVERAGE(UPS[Age for Avg]),
ALL(UPS[Location]), 
UPS[Age for Avg] <> 0
)


 




If this answers your question, kindly mark it as the solution.

cghanta's avatar
cghanta
Helper I
1 year ago

Hi mdaatifraza5556,

 

I have 2 columns on a the table UPS as follows

Location1stServiceAge2ndServiceAge
town130
town252
town360
town400
town521


How can I calculate (measure) the average age of both columns, ignoring 0's and slicer.  For the above the answer should be 19/6 = 3.17, if all zeros, give 0

Thank you in advance