topic Re: Invalid Dimension When Using An Expression in App Development

Invalid Dimension When Using An Expression

neil-devlin — Mon, 06 Oct 2025 11:31:26 GMT

Hi,

I have an issue when I try to use a claculation to display a dimension. I have a table with a list of products and and count measure of the amount of task id's associated with the product. This works fine, however I want to display a table of products where the count = 0. To do this I used the expression IF(COUNT(Task_ID) = 0,Product_Code).

To me this has always worked when using calculated dimensions, what am I doing wrong here?

Re: Invalid Dimension When Using An Expression

SunilChauhan — Mon, 06 Oct 2025 13:24:15 GMT

We cannot use aggregate function in dimension,its meant for Measure. however you want to use in dimension then

use aggr function
IF(aggr(COUNT(Task_ID),field1,field2,..) = 0,Product_Code).

where field 1 field 2 are field by which you want to aggr.

without aggr it will not work

Re: Invalid Dimension When Using An Expression

Anil_Babu_Samineni — Wed, 08 Oct 2025 00:24:13 GMT

I don't prefer to use as Calculated dimension because it degrades the performance of the object. instead, can't you do that in measure?

Re: Invalid Dimension When Using An Expression

Amit_Prajapati — Wed, 08 Oct 2025 05:15:11 GMT

Hi @neil-devlin , as @Anil_Babu_Samineni mentioned, We prefer not to use calculated dimensions since they can slow down performance. Instead, can you try doing this in a measure?

You can use a normal dimension along with a measure like COUNT(Task_ID) = 0 to filter and show only the products where Task_ID is 0.

Alternatively, you could also use a Master Dimension or Master Measure for this.