Make the Card visual display current values

[PatrickLamoste]

Hello,

I hope you can help me.

I have a measure for the Total Head Count for terminated  - 

Terminated = IF ( COUNT ( AllTerminated[Last Date Worked] ) = BLANK (), 0, COUNT ( AllTerminated[Last Date Worked] ) )

I'm trying to make the Card display only the current count for the year not the total but would also need to change when selecting  a year or years in the slicer.

Thank you!

[parry2k]

@PatrickLamoste are you looking to have year slicer on the page, and if no value selected then use current year otherwise use year from slicer?

If that is the case you can add a measure to get year selected, if not selected then default to current year 

selectedYear = SELECTEDVALUE( Table[year], YEAR(TODAY() )

once you have year, you can update your count measure and filter data on "selectedyear" measure.

[PatrickLamoste]

Yes, that is exactly how I want the Card to function. Thank you I will give it a whirl.

[parry2k]

@PatrickLamoste sounds good. feel free to reach out if need assistance.

[PatrickLamoste]

Hello,

I can't seem to make it work.

Here is my Selected Year Measure

And here is my Filter

Am I missing something here? I am fairly new to PBI.

Thanks!

[parry2k · Accepted solution]

@PatrickLamoste you second measure need change or you can club both in one, double check the syntax/table names, might be typo

Terminated Selected Year = 
VAR selectedYear = SELECTEDVALUE( AllTerminated[Termination Year], YEAR(TODAY()))

RETURN
CALCULATE(
COUNT(Allterminated[Last Date Worked]),
AllTerminated[Termination Year] = selectedYear
)