How to restrict particular fields from the given table or data...

[purna]

Given data:T1:
LOAD
"Date",
Sales,
Category,
Country,
Region
FROM [lib://DataFiles/Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

Query:

Hear i want the values of USA,IND as constant even selecting of other values in front end.

i will take IND & USA in separate KPI and remaining countries in separate KPI.

Note:  No issues if other countries value changes according to the selection in  (KPI) front end.

(Only IND & USA is restricted.)

Please help me in this issue using set-analysis in frontend.

Quick response is highly appreciable...

Thanks in advance..

Date	Sales	Category	Country	Region
1-Jan-21	261.96	Furniture	USA	California
2-Jan-21	731.94	Furniture	USA	California
3-Jan-21	14.62	Office Supplies	USA	NewYork
4-Jan-21	957.578	Furniture	IND	Andhra
5-Jan-21	22.368	Office Supplies	IND	Andhra
6-Jan-21	48.86	Furniture	UK	Lords
7-Jan-21	7.28	Office Supplies	UAE	Dubai
8-Jan-21	907.152	Technology	UAE	Dubai
9-Jan-21	18.504	Office Supplies	RUSSIA	Moscow
10-Jan-21	114.9	Office Supplies	PAKK	Lahore
11-Jan-21	1706.18	Furniture	PAKK	Lahore
12-Jan-21	911.424	Technology	SIN	Johar
13-Jan-21	15.552	Office Supplies	UK	Perth
14-Jan-21	407.976	Office Supplies	USA	NewYork
15-Jan-21	68.81	Office Supplies	IND	Bombay
16-Jan-21	2.544	Office Supplies	IND	Bombay
17-Jan-21	665.88	Office Supplies	USA	California
18-Jan-21	55.5	Office Supplies	USA	New Jersy
19-Jan-21	8.56	Office Supplies	USA	Miami
20-Jan-21	213.48	Technology	IND	Andhra
21-Jan-21	22.72	Office Supplies	IND	Andhra
22-Jan-21	19.46	Office Supplies	UK	Lords
23-Jan-21	60.34	Office Supplies	UAE	Abu_Dhabi
24-Jan-21	71.372	Furniture	UAE	Dubai
25-Jan-21	1044.63	Furniture	RUSSIA	Moscow
26-Jan-21	11.648	Office Supplies	PAKK	Lahore
27-Jan-21	90.57	Technology	PAKK	Lahore
28-Jan-21	3083.43	Furniture	SIN	Johar
29-Jan-21	9.618	Office Supplies	UK	Manchester
30-Jan-21	2542.23	Technology	USA	Washington
31-Jan-21	261.96	Furniture	IND	TS

[Vegar]

Do I understand you correctly if I give you an expression with the sum of sales for USA and IND?

You can use this:

Sum({<Country ={'IND','USA'}>}Sales)

[purna]

Thanks for the reply vegar

Sum({<Country ={'IND','USA'}>}Sales)

it will give the sum(sales) value for the both countries.

Ex: If i have total sales of both (IND & USA ) is 100.Even if i select other countrys or country the sales amount should be the same the value (100) should not be get reflect.

I will the remaining countries in separate chart & 

IND & USA in other chart.

Hope you understand now..

[purna]

Hear i have Two charts 

1) ind & usa sales

2) rest of the countries sales.

if we select any other charts we can see the values changing in ind & usa also.

But i don't want to reflect those values they should be the same.

Regards,...

[Vegar]

I am sorry, but I don't understand completely. 

You do not want any selection to affect the USA IND chart? What about using the full set and not your current selected set as a base.

Sum({1<Country ={'IND','USA'}>}Sales)