Calculated field and getting count on selected items of a dimension

• Gunther Van Loco

  SSC Veteran

  Points: 254

  More actions

  February 26, 2018 at 3:46 am

  #151543

  Hi All,

  Is there a way to get the count of checked item in a dimension into a calculation ?
  If for example I have a project and it's divided in months for following up the hours planned, the value of hours planned is the same for every month.
  I want to be able to divide the planned hours via a calculated field in the SSAS based on the number of selected items of month in the dimension date
  So instead of having for month 1 -> 6 a total of 600 hours per month I want 1 -> 6 an equal division of 120 per month, see exapmle
  How do I do this via a calculated field in the SSAS cube ? I don't want a solution for Datawarehouse, this is a quick fix requirement.