Forum Discussion

charly_bron's avatar
charly_bron
Frequent Visitor
4 years ago

Grand total sum error

I have a problem with a measure. I need to multiply [Probability of occurrences] * [Price of last purchase] * [Average consumption med. by int.]. It calculates each of the rows correctly, but the grand total returns the wrong result. I tried many formulas and watching video tutorials but it didn't fix the error.

Can you help me please!!

 

 

CT_SELECT = sumX('Tabla Mediana_medicamentos','Tabla Mediana_medicamentos'[mediana]*RELATED(Tabla_precio[px]))*[Prob de ocurrencias]
Tabla Mediana_medicamentos = SUMMARIZE(Agrup_medicamentos, [Descripción],"mediana",MEDIAN(Agrup_medicamentos[Cantidad]))
Prob de ocurrencias = divide([Cantidad_internaciones],CALCULATE([Cantidad_internaciones],ALLSELECTED(Agrup_medicamentos)))
Need Help
Tutorial Requests

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi charly_bron ,

     

    The created MEASURE calculation environment relies on external filtering contexts, slicers, row and column filters and other filtering conditions can all have an impact on the calculation results. Can you provide test data, or see if there are external filters acting on the table visual.


    Looking forward to your reply.


    Best Regards,
    Henry