Forum Discussion

av9's avatar
av9
Icon for Helper III rankHelper III
4 years ago
Solved

Filter data in heirachy

I am trying to filter data in this table so any customer above 15% should show only.   I am having troubles creating a filter that allows me to filter at this level and keep the account rows under ...
Need Help
  • av9's avatar
    av9
    4 years ago

    Still doesnt quite sort it out. Its ok I have managed to find a way to do it.

av9's avatar
av9
Icon for Helper III rankHelper III
4 years ago

Its creating the visual level filter thats the issue. Seems to always not include the 3rd level in heirarchy (Account)

 

 

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

You can try something like below which will calculate the percentage on the account level.

Account % =
CALCULATE ( [% Measure], ALLEXCEPT ( tbl, tbl[account] ) )
  • av9's avatar
    av9
    Icon for Helper III rankHelper III
    4 years ago

    Still doesnt quite sort it out. Its ok I have managed to find a way to do it.