Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need help on matrix

Hello everyone,

I want some measures regardless of column group and some measures based on column groups in the same matrix so is there any kind of custom visual available for this? If yes, could you please name that, and If not, could you please suggest what could be the best way to achieve this requirement?

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

     

    You could consider using ISINSCOPE or ISFILTERED function in a measure if you want to apply different calculation logics to different hierarchies. If you want to ignore or keep filters on some columns, you could consider using ALL, ALLSELECTED or ALLEXCEPT functions in a measure. There are some differences between these functions, you could refer to the related examples and articles in above links to learn about them and find out which would be more appropriate for your measures.

     

    If you could share some dummy data and expected result, we could help create some measures to achieve this requirement.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.