Summarize over the hierarchy that has multiplication relationship

[Anonymous]

Hello everyone, I have a data that has the following hierarchy:

                                              A

                                           /      \
                                        /            \

                                    AA              AB......

                                  /     \            /     \ 

                           AAA     AAB     ABA    ABB......

Each level will have more than two members, and there are ore than 3 levels in the hierarchy. The relationship between each level of the hierarchy is the upper level is equal to the multiplications of all members. For example, AA = AAA*AAB*AAC......, and A = AA*AB*AC......
Is there anyway that I can summarize the data and still be able to use slicer the drill down the data? Thanks.

[v-diye-msft]

Hi @Anonymous 

You might check the ISFILTERED function in DAX:

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax 

Data is too scarce to repro your issue, please consider creating a dummy pbix with tangible data and expected results, that will be better for us to provide viable suggestion.

[Anonymous · Accepted solution]

Thanks for reply. I bypassed the problem by create individual summarized table for each level of the hierarchy instead of using the automatic summarize feature in Power BI.