Forum Discussion

rlansing's avatar
rlansing
Resolver I
10 years ago
Solved

ALLEXCEPT only working on visible row context

Hello, I have a quick question. I am trying to calculate the $ Change (YOY) for a sub category, and then trying to compare that overall sub category change to specific products. Basically, we want t...
  • rlansing's avatar
    rlansing
    10 years ago

    Have you ever posted a question and then answered it immediately afterwards?

     

    Here is the solution:

    CALCULATE( [$ Vol Ch], ALLEXCEPT ( Data, Data[Date], Data[Market], Data[Sub-Cat] ), VALUES( Data[Sub-Cat] ) )
rlansing's avatar
rlansing
Resolver I
10 years ago

Have you ever posted a question and then answered it immediately afterwards?

 

Here is the solution:

CALCULATE( [$ Vol Ch], ALLEXCEPT ( Data, Data[Date], Data[Market], Data[Sub-Cat] ), VALUES( Data[Sub-Cat] ) )