Need to perform leaf level aggregation

  • morbius82000

    Old Hand

    Points: 346

    So I have a DW with  a table with some pre-aggregated scores (not my choice) and the counts of animals separated by breed and a date.

    To calculate the average score across breeds, I need to the following calculation:

    ([AverageScore]*[CountOfAnimalsForBreed])/TotalCountOfAnimals

    The problem is that when the cube rolls up for a specific date, it is not aggregating at the leaf level, so I need some thing like this:

     

    averages

    Any ideas? Thank you!

  • Martin Schoombee

    SSCoach

    Points: 19026

    You'll need to use an iterator like SUMX to force the calculation over the individual rows. What does your DAX formula look like right now (assuming that you're using Tabular).

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply