Forum Discussion

av9's avatar
av9
Helper 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.

danextian's avatar
danextian
Super 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
Helper III
4 years ago

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