Compare two categories

[Benedicts]

I have a table with sales by agent and  season like this:

agent	season	sales
agent1	AI18	12
agent2	AI18	23
agent3	AI18	32
agent1	AI19	34
agent2	AI19	23
agent4	AI19	45

I try to obtain a power bi matrix as:

agent	AI18	AI19	delta
agent1	12	34	22
agent2	23	23	0
agent3	32		-32
agent4		45	45
Total	67	102	35

Can i have an help, please?

Thanks

[tex628]

Duplicate the query, 

Filter so that you only have one season in each query,
Merge the query on agent,

Finally create the delta.

Hope this helps!

[Benedicts]

sorry but,

i have a filter, where the user can choose the season and with a lookvalue function i find the last season.

So i writed two measure to calculate the quantity like this:

QUANTITA' LAST SEASON =

VAR LASTSEASON = [selected stagione last year]

RETURN

CALCULATE(SUM(fatordspedfatt[Quantità Ordinato]);

ALL(FatOrdSpedFatt[Agent]);

ALL(fatordspedfatt[Season]);

fatordspedfatt[Season]= LASTSEASON)

The problem is that in the "last season" colum, the value are present only when there is a value in a "quantity season" colum.

I like use the measure to obtain the goal, it's possible?