Hierarchy slicer Calculation

[Anonymous]

Hi there,

Now when the Slicer got update to Hierarchy slicer in the old days I did

Calculate(
sum(table[column]),
filter (Table,column = Selected slicer1 value),

filter (table,Column = Selected slicer 2 value) etc..

How to I work with hierarchy slicer if I have lets say Stage City and other column from different table lets say Color for example

How do you combime all of these?

Thanks,

Oded Dror

[v-lid-msft]

Hi @Anonymous ,

If the 'Table' have realationship with another table used in the hierarchy slicer, it should calculate the result (Sum('Table'[Value]) automatically.

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best regards,

[Anonymous]

Hi there,

Thank you both 

Thanks

Oded Dror

[SivaMani · Accepted solution]

@Anonymous,

Here is the solution,

Calculate(
sum(table[column]),
filter (Table,column = Selectedvalue(Stage City)),

filter (table,Column = Selectedvalue(Color ))

You no need to change your existing approach for these cases since we are referencing the column value. So It will work fine!