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.

amitchandak's avatar
amitchandak
Super User
4 years ago

av9 , create a measure like this and use visual level filter

 

% filter Sales = calculate(DIVIDE([Total Sales], CALCULATE([Total Sales], all())), allexcept(table, Table[customer]))

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