Sum and filter

[RanjanThammaiah]

Hi All,

I have a question on my data. Where I need to sum up the amount based on the ID’s and filter for that amount greater than or equal to 1,00,000(Threshold).

I have tried but I can add at an visual level. But I have many visuals where the filter(Threshold) need to be changed every week. Is there any way I can change it at one shot?

The data as below. Is it possible to sum up and filter at an page level. This threshold changes everyweek.

ID	Industry	MS	GAS	AHQ	CH	Adv	Ass	CBS	TA	TX	Grand Total
111	FS	FSO	GI	Americas	2	-	21,657	163,993	-       151,111	-       127,849	-         93,310
112	TMT	Con	CO	Americas	2	12,506		-         14,504	1,998	55,478	55,478
111	TMT	Con	CO	Americas	2		115,056			14,685	129,741
112	RE	BER	CO	Americas	2		-	-	-	-	-
111	AM	BER	CO	Americas	2			-         13,605	13,605	19,111	19,111
112	FS	FSO	FC	Americas	2	20,317		-         20,317	-	42,163	42,163
113	FS	FSO	CO	Americas	1			-	-	3,873	3,873
113	TMT	Con	CO	Americas	2					-	-

[amitchandak]

@RanjanThammaiah , does a couple of solutions posted above helped you?

[Greg_Deckler]

Yes, you could create a measure that is your threshold.

Measure = 1000000

Then have all of your other measures and visuals do their filtering based on that measure. You could even use a What If Parameter to do this.

Not sure I am 100% clear on your requirements though.

[amitchandak]

@RanjanThammaiah 

Try like. Both are measures

ID sum = calculate(sum(Table[Value]),allexcept(table,Table[ID]))

Filtered  =
calculate(sum(Table[Value]),filter(table,[ID sum]<=100000))

you may have change <= to >=