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
    )

     

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!

    • parry2k's avatar
      parry2k
      Super User
      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
      )