topic Re: Filter not applied when clicking on combined dimension with table limitation in App Development

Filter not applied when clicking on combined dimension with table limitation

kai_berlin — Thu, 04 Jul 2024 14:18:05 GMT

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

Re: Filter not applied when clicking on combined dimension with table limitation

marcus_sommer — Thu, 04 Jul 2024 15:45:54 GMT

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.

Re: Filter not applied when clicking on combined dimension with table limitation

marksouzacosta — Thu, 04 Jul 2024 16:09:18 GMT

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