Forum Discussion

PatrickLamoste's avatar
PatrickLamoste
Helper I
7 years ago
Solved

Make the Card visual display current values

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[...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    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
    )

     

parry2k's avatar
parry2k
Super User
7 years ago

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's avatar
    PatrickLamoste
    Helper I
    7 years ago

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

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

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

      • PatrickLamoste's avatar
        PatrickLamoste
        Helper I
        7 years ago

        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!