Sum(Distinct Value) Trying to get the sum of?

I've got a dataset that gives me an employee count and an employee count target by location.

When I view this by location it gives me the correct values with the target value coming from the following Beastmode:




The employee count comes from this Beastmode:




When I want to see this rolled up into a market however the employee count seems to roll up fine, but the Target value is rolling up to a value of 35 which appears to be the number of entries and not the sum value of the Beastmode, it should be more along the lines of 129.

I've tried a couple of methods using Case Statements etc but to no avail.

Any ideas?




  • Is anyone able to help out with this request?

  • Hi Randy,

    I have emailed you top get some more information on the card.