Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Allexcept on multiple dimensions

Hi,   Got this problem I can not figure out, so hopefully someone can assist me with this. Below is a screenshot from a matrix visualisation on a simplified data model that shows my problem.   Fo...
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    OK. In that case, the guide here indicates that you can include it within ALLEXCEPT since it's part of the expanded table.

     

    Allexcep_Productgroup =
CALCULATE (
    [Sales],
    ALLEXCEPT ( volume, dim_date, volume[productgroup] )
)

     

AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

OK. In that case, the guide here indicates that you can include it within ALLEXCEPT since it's part of the expanded table.

 

Allexcep_Productgroup =
CALCULATE (
    [Sales],
    ALLEXCEPT ( volume, dim_date, volume[productgroup] )
)

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AlexisOlson Hi, Thanks a lot, that did the trick!