Group small values in Pie Chart

[Anonymous]

Hi

Ive created a Pie graph with my dataset and I want to group all my small values together.

Ive seen this posted multiple times but all the solutions refer to adding a calculated column, in my case I need this to work dynamically, so when the date filter is changed the Pie Graph will automatically pick up the Customers that have a market share over 10% then group all the smaller ones as "other" for that selected period. Is there a way to do this? 

[Greg_Deckler · Accepted solution]

@Anonymous I'm sure that this runs into problems somewhere but try it out. Create a measure:

Percent of All = SUM([Size]) / SUMX(ALL(Table2),[Size])

Filter the visual by this measure >.1

Now create another measure:

Other = 
    VAR __Table = ADDCOLUMNS(ALL('Table2'),"__Percent",[Percent of All])
RETURN
    SUMX(FILTER(__Table,[__Percent]<.1),[Size])

Put this measure in Values along with your other column.