Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi @stekol61 ,
You can combine your filters into one set expression like this:
=Sum({$<Graph_num={14},Country={"SE"}>}[Limit(%)])
Cheers,
LA
Hi @stekol61 ,
You can combine your filters into one set expression like this:
=Sum({$<Graph_num={14},Country={"SE"}>}[Limit(%)])
Cheers,
LA
Another way is to use it as a row level dimension ...
=if(Graph_num=14, if(Country="SE", [Limit(%)],0),0)
Cheers,
LA