add values ​​differently

[jdtobon88]

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

[v-angzheng-msft]

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.

[Greg_Deckler]

@jdtobon88 Use AVERAGE? Need some context here. Maybe MM3TR&R - Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community

[jdtobon88 · Accepted solution]

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.