stbrooks13
New Member
- Joined
- Dec 9, 2014
- Messages
- 40
I have the proper formula as follows, but in my PowerPivot table, this measure is appearing on both the Intern and Associate rows as shown in the link below. What should the formula be so that it only appears on the Intern row, as it doesn't apply to the Associate row?
=CALCULATE(COUNT(Activity[Offer Accepted]),
Activity[Offer Accepted]>0,
Activity[Job Level]="Intern",
Activity[1st or Rehire]="Rehire"
)
https://drive.google.com/file/d/0B4fCnnVL7eHCUEhGX1llTnVvaWc/view?usp=sharing
=CALCULATE(COUNT(Activity[Offer Accepted]),
Activity[Offer Accepted]>0,
Activity[Job Level]="Intern",
Activity[1st or Rehire]="Rehire"
)
https://drive.google.com/file/d/0B4fCnnVL7eHCUEhGX1llTnVvaWc/view?usp=sharing