Forum Discussion

sirlanceohlott's avatar
sirlanceohlott
Advocate III
6 years ago
Solved

Interviews Calculation

Good afternoon,    I'm running into a roadblock with a measure and I thought I'd see if anyone else can help me figure out what is happening.   The actual number of Interviews Scheduled for 12/1/...
Need Help
  • CoreyP's avatar
    CoreyP
    6 years ago

    If I'm looking at your data correctly, should your interview scheduled column just be: 

     

    Interview Scheduled = IF( 'Table'[Type of Submission] = "Interview Scheduled" , 1 , 0 )

     

    Then your measure would just be:

    Total Interviews Scheduled = SUM( 'Table'[Interview Scheduled] )

     

    Or simplify and just have a measure like this:

    Total Interviews Scheduled = CALCULATE( COUNTROWS() , 'Table'[Type of Submission] = "Interview Scheduled" )

     

    ??

CoreyP's avatar
CoreyP
Solution Sage
6 years ago

If I'm looking at your data correctly, should your interview scheduled column just be: 

 

Interview Scheduled = IF( 'Table'[Type of Submission] = "Interview Scheduled" , 1 , 0 )

 

Then your measure would just be:

Total Interviews Scheduled = SUM( 'Table'[Interview Scheduled] )

 

Or simplify and just have a measure like this:

Total Interviews Scheduled = CALCULATE( COUNTROWS() , 'Table'[Type of Submission] = "Interview Scheduled" )

 

??

sirlanceohlott's avatar
sirlanceohlott
Advocate III
6 years ago

CoreyP ,

 

I took a deeper look into the relationship view to see if there was an issue and I was able to find where the kink was, but I appreciate the simplified formula that I'll definitely keep in my back pocket for the future as I did plug it in to my model to see what would transpire.

 

Have a great Wednesday!