Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created a table where I combined two dimensions by using the following formula: "=item_number&'_'&item_name". In case I click on any row of this field two filters are applied automatically, one for item_number and one for item_name.
However in case I set a limitation for this field (since I only want so see the flop 3 rows for a specific measure) and I click again on the value of a row, nothing happens and no filter is applied.
Does anyone know if there is any workaround for this behaviour?
Best,
Kai
Hi @kai_berlin,
What @marcus_sommer is suggesting is, move your item_number&'_'&item_name formula to the Load Script and create a new field there, for example:
LOAD
item_number,
item_name,
item_number & '_' & item_name AS Item,
// Other fields ..
FROM
[YourSource]
;
As a general rule, avoid Calculated Dimensions - like item_number&'_'&item_name. Move everything to the Load Script, as much as possible. This will make your UI easier to build and faster.
Regards,
Mark Costa
Don't do this within the UI else combine everything needed within the data-model to be able to use native fields in the UI.
Hi @kai_berlin,
What @marcus_sommer is suggesting is, move your item_number&'_'&item_name formula to the Load Script and create a new field there, for example:
LOAD
item_number,
item_name,
item_number & '_' & item_name AS Item,
// Other fields ..
FROM
[YourSource]
;
As a general rule, avoid Calculated Dimensions - like item_number&'_'&item_name. Move everything to the Load Script, as much as possible. This will make your UI easier to build and faster.
Regards,
Mark Costa