How do I use SELECTEDVALUE in custom measure for Calculating Average

[Justair07]

Hi,

I thought is would be easy but I'm stuck. How can I use SELECTEDVALUE in my measure:

EPP Active Avg = CALCULATE(AVERAGE('EPP Results PBI'[EPP Score]),'EPP Results PBI'[Days Employeed]>365,'EPP Results PBI'[Status]="Active")

Instead of having a static number of 365, I was wanting to use a slicer so the user can select the value. I have a table called Days and a column called Days. I then created a sliced which is populted by the Days table and Days column. Then I tried:

EPP Active Avg = CALCULATE(AVERAGE('EPP Results PBI'[EPP Score]),'EPP Results PBI'[Days Employeed]>SELECTEDVALUE(Days[Days]),'EPP Results PBI'[Status]="Active")

and I recieve this error:

What am I doing wrong?

Thank you,

-Justair07

[AlB · Accepted solution]

Hi @Justair07 

The simplified syntax for the filter arguments does not allow that. You need the full version:

EPP Active Avg =
CALCULATE (
    AVERAGE ( 'EPP Results PBI'[EPP Score] ),
    FILTER (
        ALL ( 'EPP Results PBI'[Days Employeed] ),
        'EPP Results PBI'[Days Employeed] > SELECTEDVALUE ( Days[Days] )
    ),
    'EPP Results PBI'[Status] = "Active"
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Justair07]

@AlB  Thakn you! Perfect!