How to add an average measure between (2) columns

[Marcegon]

Hi, I am trying to add a new measure with the average of issues between (2) columns (see below).  

# of Issues - Dec	# of Issues - Jan	Average of Issues
7	15
3	5
10	7

Any help will be appreciated.  Thank you.  

[Anonymous · Accepted solution]

Hi @Marcegon ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR _dec =
    SELECTEDVALUE ( 'Table'[#of Issues - Dec] )
VAR _jan =
    SELECTEDVALUE ( 'Table'[# of Issues - Jan] )
RETURN
    DIVIDE ( _dec + _jan, 2 )

3. add a table visual with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Marcegon]

Sorry.  Forgot to mention that no matter the numbers in the (2) columns, I am getting "0, 1, and 2s"

Thank you! 

[Marcegon]

Hi, I accepted this as a solution, but I just realized it is not giving me the correct numbers.  Could you please let me know what I did wrong?  See my measure below:

Average Issues =

VAR _Current =

    SELECTEDVALUE ('Managed vs Issues - To Date'[Issues - To Date])

VAR _Previous =

    SELECTEDVALUE ('Managed vs Issues - Previous'[Issues - Previous Month])

RETURN

    DIVIDE ( _Current + _Previous, 2 )

[Marcegon]

Sorry.  Forgot to mention that no matter the numbers in the (2) columns, I am getting "0, 1, and 2s"

Thank you! 

[Anonymous]

Issue Avg = AVERAGEX(Issues, 'Issues'[# of Issues] + 'Issues'[Dec# of Issues])