Forum Discussion
reynaldo_malave
Helper III
Helper IIIMeasure Does Not Return Accurate Total
Hi Guys, I am trying to understand what is am doing wrong. I am sure this is a rookie mistake but I cant really see it. The measures is retreiving the total tickets from my sales table as a disti...
Hi reynaldo_malave ,
I can't reproduce your problem, your formula works correctly in my example data. Could you please share some example data?
Best Regards,
Winniz
amitchandak
Super User
Super Userreynaldo_malave , distinct count can be different at grand total level, and because it is recalculated you see a difference
You can force a row context column in return
example
return Sumx(values(Sales[Column]), calculate(TicketsSales - TicketsReturns))