Add records by category

[jlarques]

Hi community,

I have another challenge. I want to add all records of the same category, but first, I need to find which category it belongs to in the description column. When I find it, then I have to add the quantity to the rigth category.

How can I do that?

Thanks for all your help and support.

José Luis 

[mh2587 · Accepted solution]

measure = 

                     =IF(
      SUMX(TableName,
           FIND(
                UPPER(TableName[Category]),
                UPPER(TableName[Description])
                ,,0
               )
          ) > 0,
      SUM(TableName[Quantity]),
      BLANK()
     )

[jlarques]

This is amazing! Least than 40 seconds and I have the answer from @mh2587!!

Thank you so much @mh2587! It works!

Thanks again every community member to build this amazing community!!

Regards,

José Luis