topic Re: custom dimension not filtering in App Development

custom dimension not filtering

usr1 — Wed, 27 Apr 2022 18:45:04 GMT

I have a custom dimension for a chart where I want to display the dollar amount for a certain cost codes within a subset of types. This dimension works EXCEPT when I try to filter on either the code or type from a filter.

Example:

sum({<TY_LY={'TY'},[Code]={'A','B','C','D'},[Type]={'1','2','3','4'}>}[Dollar Amount])

Lets say that the above formula totals $100; and each Code equals $25, if the user selects 'A' from the code filter I would expect that the total would then equal $25 BUT it does not change.

Any help would be much appreciated. Thanks!

Re: custom dimension not filtering

vinieme12 — Thu, 28 Apr 2022 00:37:39 GMT

Try as below

sum({<TY_LY={'TY'},[Code]*={'A','B','C','D'},[Type]*={'1','2','3','4'}>}[Dollar Amount])

Re: custom dimension not filtering

usr1 — Sun, 01 May 2022 22:13:43 GMT

Thank you that worked perfectly!

Re: custom dimension not filtering

vinieme12 — Mon, 02 May 2022 03:17:26 GMT

Great 🙂 , kindly close the thread by accepting the response as "Solution"