expression with multiple filters

[stekol61]

Hi!

I have loaded some data from an Excel.

I want to be able to get the value in'Limit(%)' for a specific 'Graph_num' and 'Country'.

I have used this expression but it doesn't find the correct 'Limit(%)'

What can be the problem?

=Sum({$<Graph_num={14}>}{$<Country={SE}>}[[Limit(%)])

Graph_num	Limit(%)	Country
24	98	SE
24	98	DK
24	95	EE
24	95	FI
24	98	LT
24	95	NO
14	92	DK
14	90	EE
14	92	FI
14	75	LT
14	92	NO
14	92	SE

[lalphonso · Accepted solution]

Hi @stekol61 ,

You can combine your filters into one set expression like this:

=Sum({$<Graph_num={14},Country={"SE"}>}[Limit(%)])

Cheers,

LA

[lalphonso]

Another way is to use it as a row level dimension ...

=if(Graph_num=14, if(Country="SE", [Limit(%)],0),0)

Cheers,

LA