Forum Discussion
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 one of them happens again
example:
| Ref | total units manufactured |
| AA3344 | 2000 |
| Ref | workplace | sequence of operation | unids |
| AA3344 | 1CT30 | R | 2000 |
| AA3344 | 1CT30 | E | 2000 |
| AA3344 | 1CT31 | R | 2000 |
| AA3344 | 1CT32 | E | 2000 |
| AA3344 | 1CT33 | R | 2000 |
| AA3344 | 1CT33 | E | 2000 |
| TOTAL REF | 2000 |
I want to be able to see the sum as if it were a different count, where if I look at the reference level it should show me the 2000 and not the sum of all the processes involved
thanks
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.
3 Replies
jdtobon88 Use AVERAGE? Need some context here. Maybe MM3TR&R - Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
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.
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.
