This content has been marked as final.
Show 4 replies

Re: Wrong with calculation? Don't understand what I am doing wrong
Eduardo DImperio Aug 29, 2017 1:32 PM (in response to Ali Ahmad )Hi Ali,
Try SUM(Distinct YourField)

Re: Wrong with calculation? Don't understand what I am doing wrong
Ali Ahmad Aug 29, 2017 6:46 PM (in response to Eduardo DImperio)Hi,
You can see on row 4 & 5 it looks like the same values so I don't want it distinct.
What I am trying to understand if it is a modeling error or what I've done.


Re: Wrong with calculation? Don't understand what I am doing wrong
Rob Wunderlich Aug 29, 2017 7:59 PM (in response to Ali Ahmad )Your Sum() expressions are exactly 9x the Omsetning and % Of Total values. Which means they occur 9 times within your Dimension, in this case Dato. Take a look at your data model using Preview in the Data Model Viewer and try to understand why you have duplicates in your data model.
Rob

Re: Wrong with calculation? Don't understand what I am doing wrong
Ali Ahmad Aug 30, 2017 2:00 AM (in response to Rob Wunderlich )Hi,
Was missing a Distinct on a Interval Match join
Thank you!
Best,Ali A
