Forum Discussion

bolfri's avatar
bolfri
Solution Sage
3 years ago

Hi,

data that you're comparing with are different.

Record ArticuloSourceDispon ValueRotationCalculator
BUJA UNIVERSAL CORTAExcel on your screen13425355= 13425 / 355 = 37,8169014084507
BUJA UNIVERSAL CORTAPower BI134250352= 134250 / 252 = 381,3920454545455

 

Different data = Different results ðŸ™‚

Both programs did thier job and gave correct results based on provided data.

 

Dispon = SUM(Hoja1[Disponibilidad])
Rotation = SUM(Hoja1[Rotación Promedio Mensual])
Share = DIVIDE([Dispon],[Rotation])

 

  • Scarthart's avatar
    Scarthart
    Helper I
    3 years ago

    bolfri Hi, 
    How strange since all I did was export the data.

     

    Even so, I already discovered what is happening, is that when dividing the data accumulates and I do not want it to accumulate, I only take the value visible in the table

     

    bolfri 

    • bolfri's avatar
      bolfri
      Solution Sage
      3 years ago

      Is that solved your problem or do you need a SUMX calculation (measure that performes row by row and then agregate the result)? I am sorry, but I don't understand the meaning of this columns and their business meaning.

  • Scarthart's avatar
    Scarthart
    Helper I
    3 years ago

    bolfri How could I split the non-summarized data as it is splitting me only the grouped correctly