Forum Discussion
Hierarchy slicer Calculation
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
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!
3 Replies
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!
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,
