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/2019 - 12/7/2019 is 17, but when I place this measure in the report it only shows 12

 

 

 

Total Interviews Scheduled = 
SUMX(
    SUMMARIZE(HI_Interview_Scheduled_BI_DIM,HI_Interview_Scheduled_BI_DIM[jobOrderID],HI_Interview_Scheduled_BI_DIM[candidateID]),
    CALCULATE(COUNT(HI_Interview_Scheduled_BI_DIM[candidateID]))
) + 0

 

 

 

I thought I'd throw everything into a table to make sure I could see what exactly was happening and this is what I saw...

 

 

I'm seeing it is not counting some of the interviews.

 

I appreciate your help in figuring out what I should do and what the best practice moving forward for this type of issue would be.

 

Thank you,

Lance M

 

 

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" )

     

    ??

2 Replies

  • 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!