Hello, I have a question.
I have created a new Dimension [Country] as fx is: =ValueList('Swden', 'Denmark', 'Norway').
And when i´m adding a new Mesaure, i have 3 different functions (because they have each specific bookmarks that I connecting to. So for example i have the function for Denmark which should give me 20 000, but instead it gives all of them 20 000, which can see below.
| Country |
Population |
| |
|
| Sweden |
20 000 |
| Denmark |
20 000 |
| Norway |
20 000 |
Does anyone know how I can type an FX which should give me something like this
<[Country] = 'Sweden'> = function 1, <[Country] = 'Denmark'> = function 2, <[Country] = 'Norway'> for function 3,
and the result should look like this:
| Country |
Population |
| |
|
| Sweden |
60 000 |
| Denmark |
20 000 |
| Norway |
300 000 |
Right now I can create seperate KPI chart´s but it take alot of space but it works. But I tried to make it take less space and therefore I wanted to create a new table.
Best regards,
Confused_Rob
