Forum Discussion

jdtobon88's avatar
jdtobon88
Helper I
4 years ago
Solved

add values ​​differently

Cheers,   I have a table with the production history of some specific references in the plant. I need to make the sum of the references but within them there are production processes where each on...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdtobon88's avatar
    jdtobon88
    4 years ago

    Hi

     

    I finally solved it with another method.

     

    DistinctCantidades =MAXX(DISTINCT(FactReportehoras[OrdenRef]),MAX(FactReportehoras[CantTerminada]))
     
    Cantidad Fabricada = SUMX(DISTINCT(FactReportehoras[OrdenRef]),[DistinctCantidades])
     
    and the metric " Cantidad Fabricada" is the one that I take to the table and it brings me the unique values ​​so they are repeated within the exercise.
     

     

  • jdtobon88's avatar
    jdtobon88
    Helper I
    4 years ago

    Hi

     

    I finally solved it with another method.

     

    DistinctCantidades =MAXX(DISTINCT(FactReportehoras[OrdenRef]),MAX(FactReportehoras[CantTerminada]))
     
    Cantidad Fabricada = SUMX(DISTINCT(FactReportehoras[OrdenRef]),[DistinctCantidades])
     
    and the metric " Cantidad Fabricada" is the one that I take to the table and it brings me the unique values ​​so they are repeated within the exercise.