cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benedicts Frequent Visitor
Frequent Visitor

Compare two categories

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

agentseasonsales
agent1AI1812
agent2AI1823
agent3AI1832
agent1AI1934
agent2AI1923
agent4AI1945

 

I try to obtain a power bi matrix as:

agentAI18AI19delta
agent1123422
agent223230
agent332 -32
agent4 4545
Total6710235

 

Can i have an help, please?

Thanks

2 REPLIES 2
tex628 Senior Member
Senior Member

Re: Compare two categories

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 Frequent Visitor
Frequent Visitor

Re: Compare two categories

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)

 

Cattura.JPG

 

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?