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.
     

     

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, jdtobon88 

 

The value of the unids column is the total number. Although there are 6 rows about AA3344, the total number of AA3344 is 2000?Try to use the AVERAGE or MAX/MIN.

More questions?  please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.