topic sum doesnt work whole number values in Desktop
https://community.powerbi.com/t5/Desktop/sum-doesnt-work-whole-number-values/m-p/400196#M182801
<P>Hi guys,</P><P> </P><P>This is my first post so I need help to solve strange problem. I dont understand because when i use Sum it doesnt work propertly.</P><P> </P><P>Medida = SUM('Purchase Ticket'[NumberOfAdults])</P><P> </P><P>However I obteain less "numberofadults, I dont why I dont how but Im losing adults and when I compare for country as example I have got less.</P><P> </P><P>is this how I must use SUM formul to get a right work? I already see lots of post speaking about this but nothing to solve this problem</P><P> </P><P>thanksin advanced</P><P> </P>Thu, 19 Apr 2018 13:52:51 GMTeduardoav2018-04-19T13:52:51Zsum doesnt work whole number values
https://community.powerbi.com/t5/Desktop/sum-doesnt-work-whole-number-values/m-p/400196#M182801
<P>Hi guys,</P><P> </P><P>This is my first post so I need help to solve strange problem. I dont understand because when i use Sum it doesnt work propertly.</P><P> </P><P>Medida = SUM('Purchase Ticket'[NumberOfAdults])</P><P> </P><P>However I obteain less "numberofadults, I dont why I dont how but Im losing adults and when I compare for country as example I have got less.</P><P> </P><P>is this how I must use SUM formul to get a right work? I already see lots of post speaking about this but nothing to solve this problem</P><P> </P><P>thanksin advanced</P><P> </P>Thu, 19 Apr 2018 13:52:51 GMThttps://community.powerbi.com/t5/Desktop/sum-doesnt-work-whole-number-values/m-p/400196#M182801eduardoav2018-04-19T13:52:51ZRe: sum doesnt work whole number values
https://community.powerbi.com/t5/Desktop/sum-doesnt-work-whole-number-values/m-p/400208#M182807
<P>My first thought is that you might have som Slicers active or Report or Page level filters activ which affects the result from SUM. This is something I usually overlook and I end up with strange results.</P><P> </P><P>Otherwise not sure I understand the problem without example of data. Can you provide this?</P><P> </P><P>Cheers,</P><P> </P><P>OscLar</P>Thu, 19 Apr 2018 14:07:34 GMThttps://community.powerbi.com/t5/Desktop/sum-doesnt-work-whole-number-values/m-p/400208#M182807OscLar2018-04-19T14:07:34Z