Can't group table with a measure

[NoSayMe]

Hi,

I got 2 tables:
Spending:

Customers:

Measure:

Result:

Expectation:

In this example one thing is who is the customer and other which customer paid for it.

I'm summarizing how much money have selected customer had spent on different categories.

So Raechel has never been a customer for Tea only has paid for it.
In the matrix I'm trying to achieve to see Sum total of own money spent for selected customer/s grouped by all categories available in "Spending" table.

For some reason it's adding the value of Tea with Coffee, which I'm unable to solve 😕

I appreciate your help
Thanks

[amitchandak · Accepted solution]

@NoSayMe , Make there is a join between two tables and that is active.

Also, the slicer is interacting with the visual

refer if needed

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4