Identify significant contribution to parent total

Question

Hi everyone,&nbsp;desperately try to find a solution to model the following;&nbsp;As simplified exampe - I would like to know who sold significant colors (&gt;15%) in countries that contribute more than 100'000 to the total result (which is irrelevant for that view).&nbsp;I can show % of country with a percentage measure created through different levels - however, I fail then linking this to "seller".&nbsp;As well;When I apply the 100'000&nbsp;filter on the country sum, my measure calculates the new percentage, that of course is no longer the same, as minor contribution (less than the 15%) have been excluded from the country sum.&nbsp;&nbsp;columnsCountrySum CountryColourAmount colour% of CountrySeller1Switzerland50000green500010frank, paul, eric, john2&nbsp;&nbsp;red4000080frank, paul, eric, john3&nbsp;&nbsp;pink25005frank, paul, eric, john4&nbsp;&nbsp;blue25005frank, paul, eric, john5Germany200000green5000025paul, john, hans, ruth6&nbsp;&nbsp;pink8000040paul, john, hans, ruth7&nbsp;&nbsp;blue3000015paul, john, hans, ruth8&nbsp;&nbsp;grey2000010paul, john, hans, ruth9&nbsp;&nbsp;white2000010paul, john, hans, ruth10Italy150000green6000040eric, ruth, sue, sybille11&nbsp;&nbsp;Black6000040eric, ruth, sue, sybille12&nbsp;&nbsp;grey1500010eric, ruth, sue, sybille13&nbsp;&nbsp;white1500010eric, ruth, sue, sybille&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;100000&nbsp;&nbsp;&gt;15%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Result table should show the following output:&nbsp;(format can be different of course)&nbsp;columnsCountrySum countryColourAmount coulour% of CountrySeller1Germany200000green5000025paul, john, hans, ruth2&nbsp;&nbsp;pink8000040paul, john, hans, ruth3&nbsp;&nbsp;blue3000015paul, john, hans, ruth4Italy150000green6000040eric, ruth, sue, sybille5&nbsp;&nbsp;Black6000040eric, ruth, sue, sybille&nbsp;&nbsp;Looking forward to any help,&nbsp;Many thanks, Felix.

v-cherch-msft · Accepted Answer

Hi&nbsp;Anonymous
&nbsp;
You may create a measure and then add it to visual level filter&nbsp;like below.If you need further help,please share the sample file.You can upload it to OneDrive and post&nbsp;the link here. Do mask sensitive data before uploading.
&nbsp;
Measure =
IF ( [Sum Country] &gt; 100000 &amp;&amp; [% of Country] &gt; 15, 1 )

&nbsp;
Regards,
Cherie
&nbsp;

Forum Discussion

Identify significant contribution to parent total

1 Reply

Related content

Contributing to the Community

Significance testing

Identifying duplicates

Identify significant dates on a line chart

Rolling Date Identifiers

columns	Country	Sum Country	Colour	Amount colour	% of Country	Seller
1	Switzerland	50000	green	5000	10	frank, paul, eric, john
2			red	40000	80	frank, paul, eric, john
3			pink	2500	5	frank, paul, eric, john
4			blue	2500	5	frank, paul, eric, john
5	Germany	200000	green	50000	25	paul, john, hans, ruth
6			pink	80000	40	paul, john, hans, ruth
7			blue	30000	15	paul, john, hans, ruth
8			grey	20000	10	paul, john, hans, ruth
9			white	20000	10	paul, john, hans, ruth
10	Italy	150000	green	60000	40	eric, ruth, sue, sybille
11			Black	60000	40	eric, ruth, sue, sybille
12			grey	15000	10	eric, ruth, sue, sybille
13			white	15000	10	eric, ruth, sue, sybille

		>100000			>15%