Post reply

Need to perform leaf level aggregation

  • May 18, 2019 at 3:49 pm

    #3645019

    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!

  • May 21, 2019 at 2:16 pm

    #3645717

    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 1 (of 1 total)

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