Forum Discussion

Benedicts's avatar
Benedicts
Frequent Visitor
7 years ago

Compare two categories

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 ...
Tutorial Requests
tex628's avatar
tex628
Community Champion
7 years ago

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's avatar
    Benedicts
    Frequent Visitor
    7 years ago

    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?