Forum Discussion

RobJ1187's avatar
RobJ1187
New Member
5 years ago
Solved

Training tracker (Covid responders please help!)

First time posting so bear with me. We're currently pulling together completion dates for all the steps needed to deploy vaccinators to support the health service and our admin team is completely ove...
Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi RobJ1187 ,

    You could create a calculated column in PBI using the following formula

    Deployable= if([SJA E-learning]<> BLANK() && [Legal Aspects]<>BLANK()&&[Vacc Storage]<>BLANK()&&[Vacc Admin]<>BLANK()&&[Core Knowledge]<>BLANK()&&[mRNA]<>BLANK()&&[Astra Zeneca]<>BLANK(), TRUE(), FALSE())

     or a measure like

    Deployable Measure = 
if(HASONEVALUE('Table'[Person No]), 
    if(Values('Table'[SJA E-learning])<> BLANK() 
    && Values('Table'[Legal Aspects])<>BLANK()
    && Values('Table'[Vacc Storage])<>BLANK()
    && Values('Table'[Vacc Admin])<>BLANK()
    && Values('Table'[Core Knowledge])<>BLANK()
    && Values('Table'[mRNA])<>BLANK()
    && Values('Table'[Astra Zeneca])<>BLANK(), TRUE(), FALSE())  )

    Hope this helps,

     

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi RobJ1187 ,

You could create a calculated column in PBI using the following formula

Deployable= if([SJA E-learning]<> BLANK() && [Legal Aspects]<>BLANK()&&[Vacc Storage]<>BLANK()&&[Vacc Admin]<>BLANK()&&[Core Knowledge]<>BLANK()&&[mRNA]<>BLANK()&&[Astra Zeneca]<>BLANK(), TRUE(), FALSE())

 or a measure like

Deployable Measure = 
if(HASONEVALUE('Table'[Person No]), 
    if(Values('Table'[SJA E-learning])<> BLANK() 
    && Values('Table'[Legal Aspects])<>BLANK()
    && Values('Table'[Vacc Storage])<>BLANK()
    && Values('Table'[Vacc Admin])<>BLANK()
    && Values('Table'[Core Knowledge])<>BLANK()
    && Values('Table'[mRNA])<>BLANK()
    && Values('Table'[Astra Zeneca])<>BLANK(), TRUE(), FALSE())  )

Hope this helps,

 

  • RobJ1187's avatar
    RobJ1187
    New Member
    5 years ago

    That's fantastic thank you! Any tips on summary count dates vs blanks for an overview? I.e. for all the vaccinators how many have a date against it and how many are blank. As it's dates and not a numerical 1/0 it's causing me some trouble when i'm trying to use the donut. As an example i've currently got it in true/false which i can now flip to dates (thanks!)

     

    • richbenmintz's avatar
      richbenmintz
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      Hi RobJ1187,

       

      Not sure I understand the requirement, but you could use the countrows() function in conjunction with filtering to create measures that count rows where dates exist