Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum by categories (Table)

Hi Folks!   I stopped against the next wall, let's see if any good soul can help me!   As you can see in the picture, I have a TABLE with the next columns: - Production Order No_ -> From Table 1...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Finally found the solution!

     

    Cantidad Muestra TRY = CALCULATE( SUM( [Cantidad Muestra]); ALLSELECTED( ); VALUES(Table1[Sample No_]))
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

why does the column Cantidad Muestra not aggregate?

 

Try this:

Cantidad Muestra TRY =  SUMX(SUMMARIZE(Table1, Table1[Sample No_], "@Cantidad Muestra", [Cantidad Muestra]), [@Cantidad Muestra])

 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.