Group by

[danivillegas]

Hi,

I am blocked and I don't know how to move forward, and I would appreciate any help you can give me:

I need to relate the sales of a ticket to a table where sales kits appear.

The sales ticket table shows a ticket ID, the products sold, their description and the sale amount and quantity.

In the Kits table, there is a Kit ID, the name of the Kit, the ID of the products that make up the Kit, and their description.

I need to be able to search in each ticket, if all the products on the ticket are those that are part of a Kit.

Then I need you to add up the sales volume of each Kit, and the number of Kits sold in a period of time. If there is no Kit, I would like to sum the individual items.

I am trying with Group by and Contains, but I am not able to advance.

Can you help me?

Thank you very much in advance for your help!

Dani

[lbendlin]

This is the usual "filtering up" pattern.  Use measures with variables to implement your logic. Please provide sample data in usable format (not as a picture) and show the expected outcome.

[danivillegas]

Thank you very much @lbendlin !

Please find here a sample data and an explantation of what I need: https://1drv.ms/x/s!AgKUMKxrJ7KCi3aYqPik9sVLrZ7H?e=FcFqTO

Thanks for your help!

Regards

Dani