Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a problem, some of my rows duplicates the value when I use them like a measure. My measure is Sum(value):
I have an id and I tried to use distinct id and sum(value) but it doesn't works.
The correct sum is the value column (3) but the value like measure is duplicate.
Can you help me please?
Check that you are not experiencing a significant number of synthetic keys.
Those should be reduced as much as possible. If any synthetic keys appear around your 'values' field, that should be fixed.
Also, its not clear what you mean by
"The correct sum is the value column (3) but the value like measure is duplicate."
Can you be more specific?
@Frank_S wrote:
Check that you are not experiencing a significant number of synthetic keys.
Those should be reduced as much as possible. If any synthetic keys appear around your 'values' field, that should be fixed.
Also, its not clear what you mean by
"The correct sum is the value column (3) but the value like measure is duplicate."Can you be more specific?
Thanks Frank
When I use the value field as a dimension it is correct (but I can't make a sum). When I use the field as measure the number and its sum is wrong.
It appears that your values appear twice, as each sum(value) is exactly value*2. Examine your data model to determine why value is duplicated and if that is correct or not.
-Rob