Forum Discussion

reynaldo_malave's avatar
reynaldo_malave
Icon for Helper III rankHelper III
4 years ago
Solved

Measure 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 distinctcount by operation type. This means its counting sales and returns then substracts and gives back the total. If I add a filter context it shows the correct answer the problem is at the total level. 😞

 

# Total Tickets = 

var TicketsSales =

CALCULATE(
    DISTINCTCOUNT( Sales[TicketNumber] ),
    Ventas[OperationType] = 1
)        

 var TicketsReturns =

CALCULATE(
    DISTINCTCOUNT( Sales[TicketNumber] ),
    Ventas[OperationType] = 2
) 
return TicketsSales -  TicketsReturns

 

Thanks,

 

Reynaldo

 

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    reynaldo_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))

    • reynaldo_malave's avatar
      reynaldo_malave
      Icon for Helper III rankHelper III
      4 years ago

      Hi amitchandak and v-kkf-msft ,

       

      Thank you both for your replies. After taking a closer look at my numbers I found out it is working properly its just after all slicing and dicing on a matrix total become a little confusing.

       

      Once again thanks,

       

      Reynaldo