Forum Discussion

Stemar_Aubert's avatar
Stemar_Aubert
Resolver I
5 years ago
Solved

Matrix Visual: Allselected and subcategories.

Hello everyone,   Consider the following dataset:   REGION COUNTRY PRODUCT 1 PRODUCT 2 PRODUCT 3 ITEMS DATE ASIA CHINA SEDAN A3 GPS 1 01.01.2000 EUROPE PORTUGAL COUPE A7 ...
Need Help
  • Stemar_Aubert's avatar
    Stemar_Aubert
    5 years ago

    Hi parry2k 

     

    Thanks for the insights. Actually, I found out there was a slicer put out behind the visual which was impacting it, hence I could never reach 100%.

     

    Lesson learned !

     

    To handle this, I have set to use another parameter in the Calculate statement, to eliminate what is out of scope based on the slicer.

     
    I could then swap the ALLSELECTED with ALLEXCEPT, and I now have the desired results.