Get Yearly Salary Ignoring the Slicer

[kattlees]

I am trying to get a list of all employees who were employed on a specific date and their total yearly salary.

So for example, I want all employees who were employed on 10-14-18 with their whole salary for 2018.

The problem I am having is when I select a specific date, the salary changes for just that date and doesn't keep the whole year salary.

[v-lili6-msft · Accepted solution]

hi, @kattlees 

You could get it by use "ALLxxx" functions to create a measure for yearly salary like below:

Measure =
VAR selectedyear =
    YEAR ( MAX ( 'Table'[Date] ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table'[Date] ), YEAR ( 'Table'[Date] ) = selectedyear )
    )

If you need further help, please share some sample data and your expected output.

Best Regards,

Lin

[JosefPrakljacic]

I bet you need to use the ALL Function in some way.

But without an example its hard to tell what you need to do.