Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 = Selecte...
Need Help
  • SivaMani's avatar
    SivaMani
    6 years ago

    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!

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi there,

     

    Thank you both 

     

    Thanks

    Oded Dror