SSAS measure value aggregate error

Question

I have a Fact table with the following rows

When I process my cube I want results like this :

However when procession my cube I get the following results:

I have fee rate (hourly rate) as a measure but it is summing the values when LineID is the same (see value highlighted in red), even though the dates and start times are different.

How can I change my Hourlyrate measure to only display the unique value and not a summation? I have tried changing the AggregationFunction to None but this gives me null values.

score 0 · Answer 1 · answered May 18 '16 at 04:31

0

You've done a poor job of explaining your requirements and your issue.

Anyway, I would try changing the AggregationFunction for your Coll Fee Rate measure to Max. That will show the highest underlying value.

answered May 18 '16 at 04:31

Mike Honey

14,523
1
24
40

score 0 · Answer 2 · answered May 18 '16 at 16:59

0

Try changing AggregationFunction for "Fee Rate" measure to AverageOfChildren

for more details

https://msdn.microsoft.com/en-us/library/ms365396.aspx

answered May 18 '16 at 16:59

sandeep rawat

4,797
1
18
36

This is ok when the rate is the same for each line. However, when the rate is different I am getting one line with the sum of the rates, not a line for each rate. – evoandy May 24 '16 at 15:29

score -1 · Accepted Answer · answered May 25 '16 at 07:23

-1

I managed to solve this by creating a Dimension table containing the fee rates and then used to this determine the rate

answered May 25 '16 at 07:23

evoandy

630
4
16
31

SSAS measure value aggregate error

3 Answers3